When I download transactions in Quicken Essentials for Mac, my bank adds "DEBIT PURCHASE" and other junk to the Payee info.
Quicken has no ability to find and replace globally.
But I dug into the Quicken data file and it turns out all the transactions are stored in a SQLite file.
I was able to open this file with Liya and then run a query, e.g.,
UPDATE ZFIPAYEE SET ZNAME = replace(ZNAME,'DEBIT PURCHASE - ','');
which cleaned up my transactions.
Is there some way I can run this kind of query directly from Terminal without having to open up Liya and then opening the file?