Global change all for categories/memos/etc splits (Q Mac)

DrB

Is there a way to globally change a category (or any other field text for that matter)? In this case I wish to add a subcategory to a bunch of transactions that have the same incorrect category specification. In SQL it would look something like
set category to 'mynewcat:subcat' where (payee contains "UCOP" and category = 'oldcategory'). Basically, a slightly nuanced change all command. I haven't been able to find a find/change command in Q2022.

Could this be done by exporting the relevant transactions, editing them in a text editor and reimporting them? I have a feeling this would just duplicate the old transactions with the new categories and then I'd have to manually delete the old ones transaction by transaction which would probably be more work than editing the original transactions. It's a computer - I shouldn't have to click 3 or 4 times per transaction. (Is there some way to make all split information show by default in the transaction register so I don't have to keep clicking to drill into the transaction every time?). Surely there is a way to automate the process?

jacobs

See my reply in the other thread where you posted the same question. (In the future, please don't post the same question in multiple threads, as it can get confusing and wastes the time of people trying to help.)

DrB said:

Is there some way to make all split information show by default in the transaction register so I don't have to keep clicking to drill into the transaction every time?

Yes, this is a Preference setting. In Preferences > Register, click "Automatically show splits in register".

Alternatively, this is one of the keyboard shortcuts I find very much worth learning: click on a transaction and press Command-Option-S ("S" for "split") to open the transaction for editing on the split screen. 

jacobs

See my reply in the other thread where you posted the same question. (In the future, please don't post the same question in multiple threads, as it can get confusing and wastes the time of people trying to help.)

DrB said:

Is there some way to make all split information show by default in the transaction register so I don't have to keep clicking to drill into the transaction every time?

Yes, this is a Preference setting. In Preferences > Register, click "Automatically show splits in register".

Alternatively, this is one of the keyboard shortcuts I find very much worth learning: click on a transaction and press Command-Option-S ("S" for "split") to open the transaction for editing on the split screen.