[jira] [Created] (CSV-141) Some exceptions when CSV file has wrong format

["Nguyen Minh (JIRA)" <ji...@apache.org>]

Nguyen Minh created CSV-141:
-------------------------------

             Summary: Some exceptions when CSV file has wrong format
                 Key: CSV-141
                 URL: https://issues.apache.org/jira/browse/CSV-141
             Project: Commons CSV
          Issue Type: Bug
          Components: Parser
    Affects Versions: 1.0
         Environment: Windows 7
Eclipse ID for Java Developer, build id: 20130919-0819
Java 7
            Reporter: Nguyen Minh


My java application has to handle thousands of CSV files uploaded by the client phones everyday. So, there some CSV files have the wrong format which I'm not sure why.

Here is my sample CSV. Microsoft Excel parses it correctly, but both Common CSV and OpenCSV can't parse it. Open CSV can't parse line 2 (due to '\' character) and Common CSV will crash on line 3 and 4:

"1414770317901","android.widget.EditText","pass sem1 _84*|*","0","pass sem1 _8"
"1414770318470","android.widget.EditText","pass sem1 _84:*|*","0","pass sem1 _84:\"
"1414770318327","android.widget.EditText","pass sem1 
"1414770318628","android.widget.EditText","pass sem1 _84*|*","0","pass sem1

Line 3: java.io.IOException: (line 5) invalid char between encapsulated token and delimiter
	at org.apache.commons.csv.CSVParser$1.getNextRecord(CSVParser.java:398)
	at org.apache.commons.csv.CSVParser$1.hasNext(CSVParser.java:407)

Line 4: java.io.IOException: (startline 5) EOF reached before encapsulated token finished
	at org.apache.commons.csv.CSVParser$1.getNextRecord(CSVParser.java:398)
	at org.apache.commons.csv.CSVParser$1.hasNext(CSVParser.java:407)





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)