separating word or words from string

mlogan — Sun, 15 Jan 2017 04:53:29 GMT

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

Re: separating word or words from string

Shmuel — Sun, 15 Jan 2017 05:40:30 GMT

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,'()-,');

topic separating word or words from string in SAS Programming

separating word or words from string

Re: separating word or words from string