Re: Multi-level TAG selection in FIND/REPLACE?

John Pollard <[email protected]> Mon, 8 Jul 2024 10:02:50 -0500
Newsgroups alt.comp.software.financial.quicken
Organization A noiseless patient Spider
Message-ID <[email protected]>
On 07/08/24 9:57 AM, John Pollard wrote:
> On 07/08/24 7:01 AM, Andrew wrote:
>> On 7/7/2024 3:10 PM, John Pollard wrote:
>>> Are the transactions in question in one Quicken account, or multiple 
>>> accounts?
> 
>> Mostly in one main checking account, I probably could deal with the 
>> others manually.
>>>
>>> Are any of the transactions in question in an investment account?
>> Don't think so, but if they have tags, again I could deal with these 
>> roque ones manually I would suspect.
>>>
>>> Are any of the transactions in question split transactions.
>> This is probably true, but hopefully not to a great degree.  I can see 
>> myself having splits in transactions to Lowes or Home Depot that I 
>> mark partially home related, for example.
>>
>> I have over 1,000 of these transactions.
>>
>> My Plan "B" is to leave things alone, and just remember prior to move 
>> day that TAGed blanks are 'old house' and after would be 'new house'.
> 
> 
> With the exception of transactions in investment accounts, the process 
> should be relatively straight forward (assuming I fully understand the 
> issue).
> 
> I would use the All Transactions pseudo-register to make it possible to 
> find and change as many transactions as possible in one process.
> 
> Use CTRL-f Find All to find all the transactions that contain 
> "HOUSEHOLD" in the Category field.
> 
> The height and width of the resulting "Search Results" dialog box can be 
> changed. and columns shrunk/expanded, where desired to get a more 
> accurate picture of the transactions found.
> 
> You can sort the results by most, if not all, the Found fields; I 
> suspect sorting on Tag would make the process easiest.
> 
> You can then use the Select column to select the transactions to be 
> modified (noting that the top-level Split transactions will have 
> "--Split--" in the Category column - you can, and should, ignore those 
> rows).
> [Holding down the SHIFT key while clicking the first and last of a group 
> of rows works like selecting multiple files in Windows Explorer.]
> 
> The actual split lines will be displayed in blue with the text "SPLIT" 
> followed by the split line number. Those can be selected where 
> appropriate. Naturally, the non-split transactions can also be selected.
> 
> When you have Selected all the transactions you want to modify, click 
> the Edit Transactions button in the lower-right.
> 
> At the foot of the resulting Find and Replace dialog is a "Replace" 
> dropdown and a "With" dropdown. Choose "Tag" in the Replace dropdown, 
> and choose your desired new Tag value from the With dropdown (if you 
> wanted to replace a non-blank Tag with a blank Tag, you would just key a 
> Space in the With field.
> 
> Then click the Replace All button.

I should have added: backup first.