problem importing csv



-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

hi

i am stuck to using version 1.10.1 on a fedora core 11 system (library
dependencies prevent me from compiling 1.12.4), so this might have been
solved. it seems that commit d2c6d449d83ad4ced51fed4ed00a33e2d0be02ec
deals with this (or a similar) problem.

i am importing csv data as below

"string","string2","s, s2"

after the import, the double quotes become part of the values ("string1"
is in the database, not string1). glom seems not to strip the field
delimiter ("). i can partly circumvent the problem, by manually removing
the double quotes before importing but then the last field becomes a
problem. here the semi colon is part of the string, not the field separator.

regards
- -- 
Dr. Ivo Alxneit
Laboratory for Solar Technology   phone: +41 56 310 4092
Paul Scherrer Institute             fax: +41 56 310 2688
CH-5232 Villigen                   http://solar.web.psi.ch
Switzerland                   gnupg key: 0x515E30C7

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAktJ7KYACgkQAd7CE1FeMMdCqwCeKD9Evoh/HSIRZlDXRc3Eww6D
Lq0AniElo0ECUKKl8r+K7ZiCprz6qkQ/
=72Wb
-----END PGP SIGNATURE-----



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