Forum Discussion

bsmithab's avatar
bsmithab
New Contributor
7 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...
bsmithab's avatar
bsmithab
New Contributor
7 years ago


Hi tlikarish,

I have tried the approach you have suggested, since as you see in the attached snapshot the record spans over multiple line and there is only CR in one of the columns in between, I have changed the expression to replace -$content.toString().replace(‘\r’, ’ '), by this the records did not get loaded properly, the records was still not considered as single record.
Can you let us know if we need to do something else

Thanks

Regards
smitha csvparser.zip (25.5 KB)