separating word or words from string

[mlogan]

Hi All,

I have the following table with one variable call 'FullEntry'.  

FullEntry

khafiz (Kula Hafiz - Assistant Director, Vancouver, BC)
jthompson (Jill Thompson - Senior Education Officer, New York, NY)
tkewen (Tom John Kewen - Office Assistant, Los Angeles, CA)

I want to separate it out as follows. Can someone help please.

USER_ID          Name                 Position                                  City               State

khafiz               Kula Hafiz           Assistant Director                  Vancouver      BC
jthompson       Jill Thompson      Senior Education Officer       New York        NY
tkewen            Tom John Kewen  Office Assistant                     Los Angeles   CA

[Shmuel · Accepted solution]

separate by SCAN() using delimiter '()-,':

  USER_ID = scan(FullEntry,1,'()-,');

  Name      = scan(FullEntry,2,'()-,');     

  Position  = scan(FullEntry,3,'()-,');   

  City         = scan(FullEntry,4,'()-,'); 

 State        = scan(FullEntry,5,'()-,');