Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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.
New Contributor III

long string into data field

I have a long string in text file.


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


LOAD SubField(Name, '<', 1) as Name;

LOAD SubField(@1, ';') as Name



(txt, codepage is 1252, explicit labels, delimiter is '\t', msq);

Community Browser