Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Form to return part of another field, but where () are used to make what is removed

Topic Labels: Formulas
127 2
Showing results for 
Search instead for 
Did you mean: 

hi, I really have no idea what Im doing here,
I have a field that is a series of number and letters followed by a ( then more letters and numbers followed by )

field 1 bob( Joe ).

and I want Bob the amount of chariters inside and out of () is variable, the only thing I can go off of is the ()

2 Replies 2

Hi Michael, give a formula field with this a shot: REGEX_REPLACE(Name, '\\(.+?\\)', '')

Screenshot 2022-11-11 at 5.31.32 PM

Link to base

this is great, thank you very much!