How to properly parse CSV file to 2d Array?

Question

I'm trying to parse a csv file into a 2d array, where each row is a data entry and each column is a field in that entry.

Doing this all at once simplifies and separates my processing code from my parsing code.

I tried to write a simple parser that used String.Split to separate file by commas. This is a horrible approach as I have discovered. It completely fails to parse any special cases like double quotes, line feeds, and other special chars.

What is the proper way to parse a CSV file into a 2d array as I have described?

Code samples in Java would be appreciated. The array can be a dynamic list object or vector or something like that, it just has to be indexable with two indexers.

Karl Johansson · Accepted Answer · 2010-09-01 13:35:00Z

0

Have a look at Commons CSV?

CSVParser parser = new CSVParser(new FileReader(file));
String[] line;
while ((line = parser.getLine()) != null) {
     // process
}

answered Sep 1, 2010 at 13:35

Karl Johansson

1,7511 gold badge13 silver badges15 bronze badges

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

Comments

Andreas Dolk · Accepted Answer · 2010-09-01 13:40:45Z

0

If your file has fields with double quoted entries that contain separators and fields with line feeds, than I doubt that it is a real csv file... a proper csv file is something like this

1;John;Doe;engineer,manager
2;Bart;Foo;engineer,dilbert

while this is "something else":

1;John;Doe;"engineer;manager"
2;Bart;Foo;
   "engineer,dilbert"

And the first example is parseable with String.split on each line.

answered Sep 1, 2010 at 13:40

Andreas Dolk

115k20 gold badges185 silver badges275 bronze badges

1 Comment

CodeFusionMobile Over a year ago

CSV files can be much more complicated. Read this formal spec here: supercsv.sourceforge.net/csvSpecification.html and you'll see that newlines, double quotes and such are allowed within quotations

Collectives™ on Stack Overflow

How to properly parse CSV file to 2d Array?

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related