How to Import CSV files With Carriage Return in String

Goal

When parsing a pipe delimited file, carriage returns might appear in the string. Datameer is unable to parse this data line, as the data from the point of carriage return is treated as the next logical data.

Learn

Quoted CSV files might span multiple lines. To work around this behavior, configure the maximum number of lines allowed for one record in your CSV Import Job configuration under Data Detail and Advanced at Max lines per record. Set it to maximum amount of line break a quoted string could contain. 

Test File

You can test this configuration with the following file: