On 24 Sep 2009, at 8:37pm, C. Mundi wrote:

> 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.

Sorry, but you didn't miss anything, no such facility exists.   
The .import command does not handle quoted fields correctly, as has  
recently been stated on this list.  Some third-party tools do it fine  
but if you want to import your particular file you'll have to tweak  
your file so that whatever you're using as a separator never appears  
inside a field.

Simon.


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

Reply via email to