At 12:40 PM 10/6/2008, Marco van de Voort wrote:
In our previous episode, Frank Peelo said:
> >>CSV is occasionally referred to as something other than "Comma Separated
> >>Values". I'm not sure why.
> >
> >
> > Because the comma is a bad separator for countries where the comma is the
> > decimal separator, like most of mainland Europe.
>
> But CSV handles that fine!
CSV is just that comma separated.
Quoting is one common workaround. Another is to use a different separator.
And iirc Excel does that sometimes too. Maybe it is version dependant.
Sorry, but that is rather application depended. And there are a lot
that handle, both for writing and reading, "quoted" fields not
properly, though there is a relevant RFC about this in RFC4180
(http://tools.ietf.org/html/rfc4180)
My favorite "csv" experience is to get csv's from the web opened in Excel,
for both Dutch as English locales. Really a sport :-)
I do this a lot, in and out of Excel and other application and Excel
in fact handles this better than anything else. If the CSV file has
been written properly to begin with...
Ralf
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal
