4 Replies Latest reply: Jun 12, 2015 3:40 PM by Rob Wunderlich RSS

    Import delimited text file that spills over to new line

    Hampus Andersson

      Hi all!

       

      I'm trying to import a text file that is semicolon delimited. The only problem is that some lines spill over to the next line which creates a problem that the end of the line gets registered on a new column. For example like this:

       

      Id;Dateline;UserId;FullName;Email;

      AAA;BBB;CCC;DDD;EEE;

      VVV;WWW;XXX;YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY

      YYYYY;ZZZ;

       

      In the "Id" column that gives the values:

      AAA

      VVV

      YYYYY

       

      But I only want it to get:

      AAA

      VVV

       

      Is there any way of doing this or do we need to restructure our data?