[GNC] Transaction regex help

Michelle michelle at msknight.com
Wed Feb 8 08:17:58 EST 2023


Hi Geoff,

Thanks for this. I have, indeed, been driving myself slightly insane
with the Posix regex. I might do some more reading on the default
transaction filter to see what it can do... I might have gone to Posix
too soon.

I'll give the searches a try. Thanks very much.

Michelle.

On Wed, 2023-02-08 at 23:12 +1100, Geoff wrote:
> 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