Reading a CSV file with line breaks in quoted field

andersa

Greetings

 

I am trying to read a CSV file that contains line breaks within a quoted field, but the file is read incorrectly.

 

Is this not possible?

 

Regards

Anders Andersen

YYH

Hi Anders,
What's the delimiter/column separator in your csv file? Most cases should be using comma or white spaces as seperators.

Read CSV is very powerful data connector, http://docs.rapidminer.com/studio/operators/data_access/files/read/read_csv.html
The only challenge is to correctly set the values for 'column_seperators' and check 'use_quotes' in your case.

If possible, can you share your sample csv file and we can help you configure the settings in Read CSV.

Thomas_Ott

In cases like this, it might be good to use the Regular Expression paratmers in the Delimiter parameters of the Read CSV operator to extract everything. Of course it will be more complex but it's doable. 

andersa

Hi everybody

 

Thanks for the replys.

 

I have attached a simple example.