Support Forums: Message List - Reading L10n Comma-Separated Values

Give FlatPack a go..

Wed, 09 Nov 2011 13:52:49 -0500

FlatPack is an Apache 2 open source project that handles CSV or fixed-width parsing.

...

Superb CSV library

Wed, 09 Nov 2011 07:06:04 -0500

I find SuperCSV to be quite superb when it comes to reading CSV :-)

Specifying the separator for Excel

Wed, 09 Nov 2011 07:04:24 -0500

In the Nordics, CSV is separated by semicolon.

If you're producing CSV solely for Excel you can put the following text on the first line to specify the separator as semicolon: sep=;

I believel sep=, works as well.

opencsv

Tue, 08 Nov 2011 23:21:28 -0500

Also, apache commons-lang has a pretty good utility for parsing delimited text. Notice I don't say "comma delimited text". It has lots of options for delimiters, quote characters, ignoring empty values, trimming leading and trailing white...

opencsv

Tue, 08 Nov 2011 14:53:05 -0500

But OpenCSV is actually pretty good and handles this madness for you.

That's why he uses opencsv:

"For reading CSV files we are going to use openCSV library."

Oh please...

Tue, 08 Nov 2011 14:01:37 -0500

First off, CSV isn't a lot of things.

...

Reading L10n Comma-Separated Values

Tue, 08 Nov 2011 12:29:56 -0500

Although you can think that Comma-Separated Values (CSV) files are simple files where each value is separated by commas, it is far from reality. The most important part of CSV files are delimiters, and one can think...