Thanks Richard, in the end I added the quotes using some SED and AWK as
I'm using SQLite as part of a BASH script.
Thanks
On 2017-06-13 14:36, Richard Hipp wrote:
SQLite does not provide that capability, that I recall.
But surely it would not be too difficult for you to do your own custom
patch, or even to write a short program to output the data in the
precise format you desire?
On 6/12/17, d...@dan.bz <d...@dan.bz> wrote:
Hi,
When outputting to CSV with '.mode csv' is there a way that all rows
can
be quoted even if there are no spaces? For example, here is a 1 line
from the output:
spotify:track:5vlDIGBTQmlyfERBnJOnbJ,Kiso,Circles,100.019
I would like it to output:
"spotify:track:5vlDIGBTQmlyfERBnJOnbJ","Kiso","Circles",100.019
Thanks!
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
