Split String Function In QlikView

[#1]

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

[Miguel_Angel_Baeyens · Accepted solution]

Hello,

Use

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

Hope that helps.

[#3]

Thanks

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

[Karim_Khan]

Very Quick for solution Thanks