Re: [sqlite] problems on importing quoted csv files

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

Re: [sqlite] problems on importing quoted csv files

I made one, as a command line tool. the announcement: http://spointeau.blogspot.com/2011/03/sylisa-csv2db-is-born.html the sources: https://gitorious.org/sylisa-csv2db/sylisa-csv2db Another option, you can also use the shell (in python) apsw http://apidoc.apsw.googlecode.com/hg/index.html

Re: [sqlite] problems on importing quoted csv files

[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of jiajianying Sent: Monday, May 16, 2011 22:53 To: sqlite-users@sqlite.org Subject: [sqlite] problems on importing quoted csv files Hello, I'm using sqlite to process some csv files. It is very disappointing that sqlite's csv mode doesn't support

[sqlite] problems on importing quoted csv files

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