Reading a CSV file with line breaks in quoted field

andersa
andersa New Altair Community Member
edited November 2024 in Community Q&A

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

Tagged:

Answers

  • YYH
    YYH
    Altair Employee
    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
    Thomas_Ott New Altair Community Member

    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
    andersa New Altair Community Member

    Hi everybody

     

    Thanks for the replys.

     

    I have attached a simple example.

     

Categories