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...
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.