Re: [GNC] Transaction regex help

2023-02-08 Thread Michelle
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, 202

Re: [GNC] Transaction regex help

2023-02-08 Thread Geoff
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, y

Re: [GNC] Transaction regex help

2023-02-08 Thread Michelle
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-0

Re: [GNC] Transaction regex help

2023-02-08 Thread Adrien Monteleone
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 f

Re: [GNC] Transaction regex help

2023-02-08 Thread Adrien Monteleone
Is this for a Transaction report? Simply don't include that account in the Accounts tab of the report Options. Regards, Adrien On 2/8/23 4:01 AM, Michelle wrote: I've been bashing my head against this for a while. I'm after a grocery report, so I want everything that I buy from Sainsburys, M&

Re: [GNC] Transaction regex help

2023-02-08 Thread Michelle
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. Michelle. On Wed, 2023-02-08 at 10:01 +, Michelle wrote: >

[GNC] Transaction regex help

2023-02-08 Thread Michelle
I've been bashing my head against this for a while. I'm after a grocery report, so I want everything that I buy from Sainsburys, M&S, Iceland... but not if it is clothes. I've got as far as picking out all the stores using Regex in the transaction filter... Sainsburys|Iceland|Marks & Spencer ..