4 Replies Latest reply: Nov 12, 2015 9:24 AM by Anders Grimstad RSS

    Convert string (comma separated) to multiple columns

      Dont ask me why but I have some values stored as comma separated values(CSV) in a column.

      I am basically trying to make a loadscript that simulates a excel CSV import, where each of the delimited values end up in a separate column.

       

      Below is an example of two rows in one column:

      6000000, , '6006627, '6005599, '6005203, '6003813, '6105008001, '1050006765

      , '6002000, '6002092, '6002012, '6006995, '6007703, '6001080, '6206001175

       

      The output that i am looking for is:

      Header 1Header 2Header 3Header 4Header 5Header 6Header 7Header 8Header 9
      6000000'6003000'6005599'6005203'6003813'6105008001'1050006765
      6000000'6002092'6002012'6006995'6007703'6001080'6206001175

       

       

      Please note that there might be more than 7 delimited values and as you can see the length of each value also varies :/

       

      Appreciate any help!

       

      Best Regards,

      Anders