Re: csv (comma separated value) file

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, 3 Aug 2009, Paolo Bacchilega <paolo.bacchilega@xxxxxxxxx> wrote :
it's not so easy, for example the following csv file:

"a;b";c

has only two columns, you cannot handle this case with a simple g_strsplit call

And for extra fun, I've recently had to handle a CSV format where the first line was:
CSV version 2,.,*,",
when generated in the UK and:
CSV version 2;,;*;";
when generated by our Italian customer. And yes, that does mean that the Italian version used ; as the separator and , for the decimal place, rather than , for the separator and . for the decimal. It also means that both versions use " for quoting, and a line beginning with * is a comment. The tool reading this file is expected to deduce the correct format from that first line.
--
Rob Pearce                       http://www.bdt-home.demon.co.uk

The contents of this | Windows NT crashed.
message are purely   | I am the Blue Screen of Death.
my opinion. Don't    | No one hears your screams.
believe a word.      |
_______________________________________________
gtk-list mailing list
gtk-list@xxxxxxxxx
http://mail.gnome.org/mailman/listinfo/gtk-list

[Index of Archives]     [Touch Screen Library]     [GIMP Users]     [Gnome]     [KDE]     [Yosemite News]     [Steve's Art]

  Powered by Linux