[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 Justin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] problems on importing quoted csv files
Justin, If you're comfortable with perl, try perl's Text::CSV module with DBD::SQLite. I have used Text::CSV, which has a good set of format options that it parses. I have not used DBD::SQLite myself. Andy -Original Message- From: sqlite-users-boun...@sqlite.org [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 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 Confidentiality Notice. This message may contain information that is confidential or otherwise protected from disclosure. If you are not the intended recipient, you are hereby notified that any use, disclosure, dissemination, distribution, or copying of this message, or any attachments, is strictly prohibited. If you have received this message in error, please advise the sender by reply e-mail, and delete the message and any attachments. Thank you. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 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