Help

Remove unwanted characters

Topic Labels: Formulas
Solved
Jump to Solution
2095 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Dennis_Petrou
7 - App Architect
7 - App Architect

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!

1 Solution

Accepted Solutions
Per_Carlen
7 - App Architect
7 - App Architect

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)","")

See Solution in Thread

2 Replies 2
Per_Carlen
7 - App Architect
7 - App Architect

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!