6 Replies Latest reply: Mar 7, 2013 7:24 AM by Michael Kühn RSS

    Load nested CSV

    Michael Kühn

      Hi,

      I've got the problem, that I have CSV file with the structure:

      Data
      Remark
      0001 2012, 12345678
      Time: 05.01.2012
      Pos Time Value
      1         12      41,5625
      2         41      41,5687522888184
      3         72      41,5687522888184
      0002 2012, 12345678
      Time: 06.01.2012
      Pos Time Value
      1         29      39,0499992370605
      2         59      39,1312522888184
      3         89      39,1937522888184

       

       

      The list of values continues a lot of times. So this is only an example.

       

      On loading the CSV, I would like to have a table like this:

       

      Pos0001 20120002 2012
      141,562539,0499
      241,568739,1312
      341,568739,1937

       

      Any other blocks in the CSV file should result in an additional column. The header rows and the blank lines should be skip!

       

      Does anybody has an idea to accomplish that.

       

      Many thanks

       

      Michael