Discover what data silos are costing your org in our commissioned Forrester study. Learn more
Nov 10, 2022
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 ()
Nov 11, 2022
Hi Michael, give a formula field with this a shot: REGEX_REPLACE(Name, '\\(.+?\\)', '')
REGEX_REPLACE(Name, '\\(.+?\\)', '')
Link to base
Nov 16, 2022
this is great, thank you very much!