2 Replies Latest reply: Dec 30, 2015 10:35 AM by Roman Dahl RSS

    splitting a dynamic ";" string into several columns?

      Hi,

       

      Can you please tell me what is the most efficient way of getting a column which is a string consisting of several variables seperated by ";" (please see below) to split into several columns (one column for each variable between the ";"'s)

      Needs to be done in the load script.

       

      (Load script)

      SQL select Date, ColumnToSplit from MyTable;

       

      (Result Now)

      Date: 01.01.2001

      ColumnToSplit: 4682.50;2;1451481191401;165017;4689.47399965;true;

       

      (Result Needs to Be)

      Date: 01.01.2001

      Column1: 4682.50

      Column2: 2

      Column3: 1451481191401

      Column4: 165017

      Column5: 4689.47399965

      Column6: true

       

      The lenght of the numbers can be different from a line to line and the last word also (sometimes its true, sometimes its false or sometimes its missing...

       

      Thanks in advance for your help, much appretiated.