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 ()