Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
LOAD Field,
subfield(Field,';#',1) as First,
subfield(Field,';#',2) as Last
FROM ...;
like
=subfield('20;#test123',';#',1)
=subfield('20;#test123',';#',2)
LOAD Field,
subfield(Field,';#',1) as First,
subfield(Field,';#',2) as Last
FROM ...;
like
=subfield('20;#test123',';#',1)
=subfield('20;#test123',';#',2)