Split number from string

[srinivasa1]

Hi,

I have single filed like below.how i can seperate  into 2 clos like(20 and test123)

20;#test123

21;#test123145
22;#test1231456
22;#test12312we

Thanks

[swuehl · Accepted solution]

LOAD Field,

          subfield(Field,';#',1) as First,

          subfield(Field,';#',2) as Last

FROM ...;

like

=subfield('20;#test123',';#',1)

=subfield('20;#test123',';#',2)