commons-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nguyen Minh (JIRA)" <>
Subject [jira] [Created] (CSV-141) Some exceptions when CSV file has wrong format
Date Wed, 05 Nov 2014 01:57:34 GMT
Nguyen Minh created CSV-141:

             Summary: Some exceptions when CSV file has wrong format
                 Key: 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: (line 5) invalid char between encapsulated token and delimiter
	at org.apache.commons.csv.CSVParser$1.getNextRecord(
	at org.apache.commons.csv.CSVParser$1.hasNext(

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

This message was sent by Atlassian JIRA

View raw message