I have been asked to output an 'Excel'-friendly report for someone, which means dumping a "CSV" (Comma Separated Values) file.
Setting ".separator ',' " gets me part of the way. Unfortunately, I need to manually quote strings using something like this: SELECT '"' || name || '"', '"' || address || '"', zipcode FROM clients; It would be mighty handy if sqlite had a '.mode csv' option which would auto-quote strings and not quote numbers, and put commas between them. This is an extremely common format... Perhaps ".mode" is not the correct place to do this, but something similar would be great. Thanks! -- My GPG public key is at http://ronware.org/ fingerprint: 8130 734C 69A3 6542 0853 CB42 3ECF 9259 AD29 415D
