It looks like you're new here. Sign in or register to get started.
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
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.
Hi everybody
Thanks for the replys.
I have attached a simple example.
Answers
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.
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.
Hi everybody
Thanks for the replys.
I have attached a simple example.