topic Re: Split number from string in QlikView

Split number from string

srinivasa1 — Wed, 05 Feb 2014 20:53:21 GMT

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 — Wed, 05 Feb 2014 20:57:46 GMT

LOAD Field,

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

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

FROM ...;

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

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