Help

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

Topic Labels: Formulas
589 2
cancel
Showing results for 
Search instead for 
Did you mean: 
michael_frankha
5 - Automation Enthusiast
5 - Automation Enthusiast

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

michael_frankha
5 - Automation Enthusiast
5 - Automation Enthusiast

this is great, thank you very much!