Skip to main content

Hello, this is an example of a value in my NAME field:


1290 Name 3 (Some Words)

1255 Another Name 12 (more words)


I’m looking for a formula that will get rid of the numbers and space before Name, and anything in parentheses) so would result in:


Name

Another Name


Thanks for any help!

This was as close as I got. Removes all whitespace though.


REGEX_REPLACE(Name,"(\\(.*\\))|(\\d)|(\\s)","")

EDIT: Or this. Leaves whitespace, which aren’t visable in Airtable.


REGEX_REPLACE(Name,"(\\(.*\\))|(\\d)","")

This was as close as I got. Removes all whitespace though.


REGEX_REPLACE(Name,"(\\(.*\\))|(\\d)|(\\s)","")

EDIT: Or this. Leaves whitespace, which aren’t visable in Airtable.


REGEX_REPLACE(Name,"(\\(.*\\))|(\\d)","")

Thanks, this seems to work!

Reply


Terms & Conditions