XMLport cvs file extra empty lines error

CenterD

Nav. version 2013
If i import a csv file using XMLport, and some of the lines in the csv file have an extra cr/lf (there is an extra empty line) the XMLport acts as though the line before was read again.

I have:
Format Variable Text
FieldDelimiter <none>
FieldSeparator ;
RecordSeparator <<NewLine>>
TableSeparator <<NewLine><NewLine>>


Is there some workaround on this error?

Wisa123

<insert greeting clause>

Good Morning,
I dont really understand your question, like you see in the xmlport properties you posted, the XMLPort will take an empty line as TableSeperator, if the empty lines are at the wrong position its most likely that your CSV is just wrong.
There may be a workaround, but therefore i'd need a sample File to really understand your problem.

Greetings, Wisa

CenterD

Thanks, i solved it in another way.

Wisa123

May you explain your solution then?
Lots of people will end here Googling for your problem and wont be very satisfied with a thread like this.

CenterD

I would have if i could, but I completely redesigned the solution, so i don't really have any workaround or so.