CSV parser not parsing when CR is found in column content

[bsmithab]

Hi
we have a csv file which has around 40 columns and one of the column is notes column which has Carriage return (CR) in the content, due to which the CSV parser is not able to break the line properly and its making it fail in loading actual content of the record instead the record gets split into 2 and fails

We have tried in using binary document and tried replacing the value and then document to binary and then CSV parser, No luck

Any other alternatives needs to be done to handle these records

Thanks
Regards
smitha

[Matt]

What if we aren’t using quotes?

[tlikarish]

Although I haven’t tried it, I think this expression should work even if your data isn’t quoted.