CSV Parsing Error - Githubissues

AtlasOfLivingAustralia / sandbox

User testing and data upload service

https://sandbox.ala.org.au

0 stars 4 forks source link

Closed sadeghim closed 9 years ago

sadeghim commented 10 years ago

Hi,

There is a problem in parsing CVS files having empty string values shown like "" .

Sample CSV: Institution,catalogueNumber "","BGQLD.0803" "","BGQLD.0804"

Output: [Institution,catalogueNumber] [",BGQLD.0803] [ ,BGQLD.0804]

The bug is already reported and still open in opencsv project: http://sourceforge.net/p/opencsv/bugs/102/?limit=25

Cheers, Mahmoud

nickdos commented 10 years ago

Consider switching to http://supercsv.sourceforge.net/ which has much better support for Excel generated CSV files (it handles MS quirks).

sadeghim commented 9 years ago

Bug fixed!