Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a long string in text file.
Demo.txt
Zack Ryan<afda>;John Nu<ad123>;Paul Barter<33c>;David Wu<333>;Troy Naly<ad44>
I want the results to be like:
Name // Field Header
Zack Ryan
John Nu
Paul Barter
David Wu
Troy Naly
How can i achieve above.
May be this
Table:
LOAD SubField(Name, '<', 1) as Name;
LOAD SubField(@1, ';') as Name
FROM
[..\..\..\Documents\Demo.txt]
(txt, codepage is 1252, explicit labels, delimiter is '\t', msq);