Help

Discover what data silos are costing your org in our commissioned Forrester study. Learn more

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

Topic Labels: Formulas
81 2
cancel
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 )

example
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!