long string into data field

[userid128223]

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.

[sunny_talwar]

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);