8 Replies Latest reply: Feb 22, 2017 11:08 AM by buck master RSS

    Dealing with CRLF

    buck master

      Were trying to read in a file that looks something like this:

      FIELD1               FIELD2                    FIELD3

      AAA               A1 A2 A3 A4          13% 11% 9% 6%

      BBB               B1 B2 B3 B4          2% 22% 44% 5%

      CCC               C1 C2 C3 C4         7% 33% 44% 32%

       

      for each row, FIELD2 & FIELD3 are a single field with multiple entries separated by CRLF's, each are consumed as a single row as shown above, there are 3 rows in this example.

       

      Looking to visualize with a table and be able to export to excel the data so that it looks similar to below:

      FIELD1,FIELD2,FIELD3

      AAA A1 13%

      AAA A2 11%

      AAA A3 9%

       

      and so on to the EOF....

       

      Any ideas?

       

      Thanks in advance

       

      Message was edited by: buck master