Forum Discussion

bsmithab's avatar
bsmithab
New Contributor
6 years ago

CSV parser not parsing when CR is found in column content

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 prop...
tlikarish's avatar
tlikarish
Employee
6 years ago

Are you seeing an error message? Since you’re using quotes and the column is quoted, the CSV Parser should treat the carriage return as part of the column’s value and not as a row delimiter. Is it possible the quoting is off?

Matt's avatar
Matt
New Contributor
6 years ago

What if we aren’t using quotes?

  • tlikarish's avatar
    tlikarish
    Employee
    6 years ago

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