Am Dienstag, den 17.05.2011, 13:53 +0800 schrieb jiajianying:
> Hello,
>
> I'm using sqlite to process some csv files. It is very disappointing
> that sqlite's csv mode doesn't support quoted csv format. I tried
> spatialite which can only strip quote marks but can't parse it correctly.
>
> Is there any suitable modules or tools for importing quoted csv files?
>
> Thanks
>
> Justin
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Have you tried to use a tab ('\t') as the field delimiter? I tried that
when exporting a calendar from gnome evolution to a csv file and
importing it into an OpenOffice spreadsheet.
--
thomas
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
