2 Replies Latest reply: May 15, 2014 10:16 AM by biGdata _ RSS

    parsing data that is seperated by a space into seperate columns

    biGdata _

      hello world of datawatch...

       

      if i had a sample group of data in one column and would like to extract it into "7" seperate columns and the " " would be the seperator?

       

      Sample

       

      12/11/2012 ABC 123 5,000.00 2,019.15 2,018.38 2,018.38

       

      The wrinkle is that this line could have the same data repeated 10 times with different numbers:

       

      such as:

       

      1 2 3 4 5 6 7         1 2 3 4 5 6 6       1 2 3 4 5 6 8   etc.

       

      Appreciate the input..

      biGdata