#79 CSVReader doesn't read correctly file wth multi-line entries

v1.0 (example)
closed-out-of-date
nobody
None
5
2016-04-27
2011-10-19
Anonymous
No

Please, see the file attached - it's a CSV export from the YouTrack issue tracker.
I read it as
List<String[]> lines = new CSVReader( new FileReader( f )).readAll()

I then verify that all lines read have an identical size, equal to lines[ 0 ].size() (17 for this file) which is a line of headers.
But it's not so - many lines are of size less than 17, some are of size more than 17. It seems to be related to lines with a multi-line entries which CSVReader doesn't read correctly.

You can see those 3 screenshots for more details:
http://dl.dropbox.com/u/4820835/opencsv/1.png
http://dl.dropbox.com/u/4820835/opencsv/2.png
http://dl.dropbox.com/u/4820835/opencsv/3.png

Thanks!

Discussion

  • Comment has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    Anonymous - 2011-10-19
     
    Last edit: Anonymous 2013-11-21
    Attachments
  • Comment has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    Anonymous - 2011-10-19
     
    Attachments
  • Comment has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    Anonymous - 2011-10-19

    It became better when I converted all multi-lines to a single String by joining them with "<br/>" but there was still a single String[] line of an unexpected size(). Please, see "issues2.zip" and those screenshots:
    * http://dl.dropbox.com/u/4820835/opencsv/4.png
    * http://dl.dropbox.com/u/4820835/opencsv/5.png

     
  • Andreas PAX Lück

    Conversion of input data is no solution. Please fix this bug.

     
  • Andrew Rucker Jones

    • status: open --> closed-out-of-date
    • Group: --> v1.0 (example)
     
  • Andrew Rucker Jones

    Cleaning up old issues. If this still needs attention, please open a new ticket.

     

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

Sign up for the SourceForge newsletter:





No, thanks