Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Split String Function In QlikView

I have a string column in a table with ; as delimiter but number of parts are not fixed it can be 1 or 5 or 100.

Any idea how can I split the string and create separate records from it at load time.

Example:

LOAD ID,

LongString, // LongString have values like "ABC;DEF;HIJ;KLM" OR "XYZ;OPR;LMJ" OR "PPP;SSS"

RESIDENT OldTab:



Thanks

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

Hello,

Use

LOAD ID, SubField(LongString, ';') AS FieldNameRESIDENT OldTab;


Hope that helps.

View solution in original post

3 Replies
Miguel_Angel_Baeyens

Hello,

Use

LOAD ID, SubField(LongString, ';') AS FieldNameRESIDENT OldTab;


Hope that helps.

Not applicable
Author

Thanks

It worked very well...never knew I could use subfield without field_no parameter.

Karim_Khan
Creator III
Creator III

Very Quick for solution Thanks

KK