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@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@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@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.
