java.io.IOException: Un-terminated quoted field at end of CSV line

Question

I have a CSV file(written in german language) and I m parsing it in my code.

CSVParser newLineParser = new CSVParser('\n');

        try {

            String[] points = newLineParser.parseLine(csv);
            CSVParser commaParser = new CSVParser();
            int pointsLength = points.length;

            for (int i = 1; i < pointsLength; i++) {

                String[] pointComponents = commaParser.parseLine(points[i]);
            }

        } 
        catch (Exception e) {
            Log.e("Exception", e.getMessage());
        }

I am getting error in the parseLine method as:

java.io.IOException: Un-terminated quoted field at end of CSV line

what may be the reason for this error?

Tim S. · Accepted Answer · 2011-02-11 09:00:18Z

1

What I get from this is that in your CSV file a quote is opened but isn't closed.

answered Feb 11, 2011 at 9:00

Tim S.

13.9k9 gold badges49 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Anh-Tuan N. · Accepted Answer · 2016-04-13 23:04:56Z

0

If you are using OpenCSV API then this could be the problem:

Issue: One or more value in the csv file have multiple lines.

Fix: Use commaParser.parseLineMulti(points[i]) instead.

Source: Http://opencsv.sourceforge.net/apidocs/com/opencsv/CSVParser.html#parseLineMulti(java.lang.String)

answered Apr 13, 2016 at 23:04

Anh-Tuan N.

363 bronze badges

Comments

checkandy · Accepted Answer · 2011-02-11 09:02:19Z

-1

malformed csv file

do some printouts in your loop, to see what happens before the program blows up.

answered Feb 11, 2011 at 9:02

checkandy

272 bronze badges

Collectives™ on Stack Overflow

java.io.IOException: Un-terminated quoted field at end of CSV line

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related