Bad CSV output

Julien Ponge julien.ponge at insa-lyon.fr
Wed Jan 8 04:32:13 PST 2014


Hi Gilles,

> Couldn't this just be some locale problem?
> I see that you have a french version of MS Excel and in the french locale of some softwares the value separator for CSV is a semicolon (this is true for most locale where the coma is the decimal separator).

No, my locale is en_US:

$ locale
LANG="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_CTYPE="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_ALL="en_US.UTF-8"
$

Excel is in French due to the purchased version being French, as if "the vendor" could not do a multi-locale distribution :-)

I get the very same problem with Apple Numbers.

> That being said there is definitely a discrepancy between the column names and the column that are being output. In particular, I think the data rows do not contain the advertised 95 and 99% mean errors but only one mean error.

I suspect some of entries should make use of double-quotes, too.

- Julien


More information about the jmh-dev mailing list