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