My field has a name followed by a number - SAM ADAMS (1234). I need to put the 1234 in it's own field. What is the best way to write a formula to do that?
Extract numbers from field into a new field
+7This topic has been closed for replies.
+25Try this:
MID({field name}, FIND("(", {field name})+1, LEN({field name})-FIND("(", {field name})-1)
Here is the formula using Regex.
IF(
{Name&Number},
REGEX_EXTRACT(
{Name&Number},
"\\((\\d*)\\)$"
)
)
+35Actually, I just looked this up — this is the formula you would use to extract numbers from a string of text:
IF(
{text},
REGEX_REPLACE({text}, "\\D", "")
)
+7Actually, I just looked this up — this is the formula you would use to extract numbers from a string of text:
IF(
{text},
REGEX_REPLACE({text}, "\\D", "")
)
Thanks, Scott. I used an alternative method not the regex function.
+35Another way of doing this could be to use Airtable's VALUE() function, but that is highly unpredictable since it also performs math! So use that one with caution.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.