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)
