#11 How to deal with Improper double & Single quotes

closed
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

  • Comment has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    Anonymous - 2011-04-08

    Sample CSV

     
  • 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.

    :)

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks