[GNC] Transaction regex help

Geoff cleanoutmyshed at gmail.com
Wed Feb 8 07:12:34 EST 2023


Hi Michelle

GnuCash has implemented the "POSIX" dialect of regular expressions, and 
I don't think it supports the complex example with negation you gave in 
your earlier post:-

https://www.ibm.com/docs/en/watson-explorer/11.0.1?topic=queries-posix-regular-expression-syntax-examples

However, you may be able to achieve your desired result if you try using 
the Search functionality instead - this post and screenshot may be helpful:-

https://lists.gnucash.org/pipermail/gnucash-user/2022-July/101780.html

If you manage to filter the required transactions using Search (or a 
series of Searches, remember that you can:-
* Refine the results of a previous Search
* Add results to the current Search
* Delete results from the current Search
)
then you can produce a Transaction Report by choosing:-
Reports / Account Report.

Hope this helps.

Regards

Geoff
=====

On 8/02/2023 9:36 pm, Michelle wrote:
> I gave a bad example. In trying to make the example simple, I opened up
> a solution.
> 
> Consider text to be in the description which would be a negative for
> wanting to summarise some transactions in a series of what would
> otherwise be placed in a -Cat:Computer:Hardware line.
> 
> Michelle.
> 
> On Wed, 2023-02-08 at 04:14 -0600, Adrien Monteleone wrote:
>> Also, do you not split your receipts by line item?
>>
>> That would make this a cinch.
>>
>> Regards,
>> Adrien
>>
>> On 2/8/23 4:10 AM, Michelle wrote:
>>> I think part of my problem may be that in the transaction filter,
>>> the
>>> account name may not be included as part of the comparison, but
>>> even
>>> then if I try various forms of "not clothing" in the account
>>> filter,
>>> that's not working either.
>>
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


More information about the gnucash-user mailing list