ETL and Data Integration tools - Modern ETL software for everyone

Hi


I am trying to import the file using Advanced ETL processor

The reader is set up for UTF-8, comma delimiter, double quote text qualifier, CR and LF line terminator.

While I can open the CSV file OK in Excel, the reader is showing that I have four records instead of 2.

Any ideas how I can solve this?

I have tried using escape strings, but the reader is getting to the file before I can apply any of the transformations.

Kind regards,
Andrew

Can you email us the file please

Mike

You have CR+LF within the filed itself so it is a new line

If you had just CR or just LF... it would work than

How do you generate the file?

Peter