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 something like this: >
Oh! I just saw that sqlite3 has a ".mode cvs". Two comments: 1) the help says 'csv' instead of 'cvs'. 2) the mode is exactly the same as 'list'. It should double-quote output strings. -- My GPG public key is at http://ronware.org/ fingerprint: 8130 734C 69A3 6542 0853 CB42 3ECF 9259 AD29 415D
