#11 How to deal with Improper double & Single quotes

closed
Scott Conway
None
5
2011-06-14
2011-04-08
Anonymous
No

How to deal with[while reading] improper [unclosed] double as well as single quotes in a CSV file.
As given in the attachment.

Discussion


  • Anonymous
    2011-04-08

    Sample CSV

     
    Attachments
  • Scott Conway
    Scott Conway
    2011-06-14

    • assigned_to: nobody --> sconway
    • status: open --> closed
     
  • Scott Conway
    Scott Conway
    2011-06-14

    Look at issue 3314579 for the code example - they had the exact same issue you had.

    Just turn on ignoreQuotations and it will treat all quotes inside the field as part of the field.

    :)