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:


      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