topic long string into data field in QlikView

long string into data field

userid128223 — Thu, 04 May 2017 18:34:11 GMT

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 — Thu, 04 May 2017 18:51:26 GMT

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