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