Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

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

Topic Labels: Formulas
1314 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!