SQLite Forum

Set diferent Quote Character
Login
You may have to mangle your input data if possible to replace double quotes with single quotes. I had a situation where I wanted output delimited by the pipe character and did this:

<code>
sqlite> select * from keywords limit 20;
sqlite> .output /Users/user/Desktop/fubar.txt
sqlite> .separator |
sqlite> select * from keywords limit 20;
</code>