Extract data from a field using a delimiter character

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column with the following values
SCL (LP Steam Condensate)
WF (Fire Water)
P (Process Piping)
Click to expand...
etc...

I need to extract only the characters inside the parenthesis (i.e.LP Steam
Condensate or Fire Water or Process Piping). I thought using the Left
Function but since the length is variable I am not sure how to set it so it
uses the parenthesis as delimiter. Thanks in advance.
Bruno
 
Mid(Mid(String, Instr(String,"(")+1),Instr(Mid(String, Instr(String,"(")+1),")
")-1)

I think all the parentheses are in there correctly. Anyway, you get the idea.
HTH.
 
Back
Top