Hi.  I have scanned the list archives and Googled.  I may have missed
something, but what I found was not sufficiently general or robust for my
needs.

Happily, sqlite has a very nice .output mode for CSV.  It correctly
double-quotes fields when they contain a space or a comma, and it correctly
'escapes' double-quote literals as "".  Great!  I need to go the other way.

I don't see an inverse .import mode in sqlite to handle the completely
general CSV syntax.  As anyone who has ever tried knows, parsing compliant
CSV is a lot harder than writing compliant CSV.

I'm hoping someone will (please) tell me I missed something in the sqlite
docs.  Otherwise, I guess I'll be using python's csv module to turn my CSV
file into SQL insert statements.  This is likely to be an infequent task,
but it has to be done perfectly.  So if someone knows of a command-line tool
to turn CSV into SQL inserts, I would appreciate that too.

Thanks,
Carlos
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to