Can I run an SQLite operation from Terminal?
Solution 1:
Yes. You can use the /usr/bin/sqlite3
command line tool to modify the database. It ships, default, with OS X so you don't need to do anything other than open a Terminal window and then run:
cd path/to/quicken/storage/directory
sqlite3 <quicken database file>
SQLite version 3.7.13 2012-07-17 17:46:21
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> UPDATE ZFIPAYEE SET ZNAME = replace(ZNAME,'DEBIT PURCHASE - ','');
sqlite> .quit
You can do it all from one command line like this if you like:
sqlite3 <quicken database file> 'UPDATE ZFIPAYEE SET ZNAME = replace(ZNAME,\'DEBIT PURCHASE - \',\'\');'
That will open, modify and close your database file and return the prompt.
For more information on using the SQLite command line too see: http://www.sqlite.org/sqlite.html