2 Replies Latest reply: Feb 18, 2011 10:23 AM by Sandip1981 RSS

    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