[sqlite] PATCH: [sqlite] sqlite output request: .mode csv

On Mon, September 13, 2004 12:14, Ron Aaron said: Responding to my own complaint: here is a patch against current CVS version, fixing the typo in the '-help' and implementing ".mode cvs" properly (at least, in my opinion) -- My GPG public key is at http://ronware.org/ fingerprint: 8130 734C 69

Re: [sqlite] sqlite output request: .mode csv

On Mon, September 13, 2004 8:28, Ron Aaron said: > 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 someth

[sqlite] sqlite output request: .mode csv

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 |