Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
amiumi66
New Contributor III

long string into data field

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.

1 Reply

Re: long string into data field

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

Community Browser