CSV reader

#1

I have a large .csv file with line breaks within the cells that are not surrounded by double quotes. When I try to read the file into Knime it sees the line breaks as a new delimiter and disrupts the cell. Is there a 'fix' for this. Thanks.

Michele

0 Likes

#2

you can change the row delimeter to something different than \n (line break), but then you are not going to have new rows in your dataset.
Reading the file with no delimiters and processing it, might be the best solution for you.
Could you share a small sample (1-10 rows) of your dataset to have a better view on the issue?

Nick

0 Likes