topic Split String Function In QlikView in QlikView

Split String Function In QlikView

Fri, 18 Feb 2011 14:44:14 GMT

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 — Fri, 18 Feb 2011 14:49:28 GMT

Hello,

Use

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

Hope that helps.

Fri, 18 Feb 2011 15:23:28 GMT

Thanks

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

Karim_Khan — Thu, 30 Apr 2020 14:36:10 GMT

Very Quick for solution Thanks