[GNC] filtering in report

Andy andy at hentze.info
Mon Feb 7 15:18:16 EST 2022


Hi Geoff,

thanks for the detailed description!!

Yes, I work with 'Transaction Report'.

Unfortunately it is not so easy:
The number of accounts in the tree differs, I cannot start from the 
beginning. So I start at the end: "[br]$" to check that all accounts 
ending with "chor" and "club".

As this finds "Anzeiger" too I modified to "[uo][br]$", which works 
fine. Next step is trying the complement: "[^uo][^br]$"
But this does not work as "Anzeiger" ist although filtered out.

I do not really understand why this does not work.

best regards
Andy


Am 07.02.22 um 02:57 schrieb Geoff:
> 
> ... 
> Which leads us to a possible hacky workaround for your scenario - this 
> regular expression will do the job - see attached screenshot for proof:
> 
> ^.+:.+:.+:[^GR]
> 
> For those not familiar with the arcane art of regular expressions, let's 
> break this down.  Remember that my chart of accounts is slightly 
> different to yours, and I have a colon ':' as a delimiter, not a full 
> stop '.'  Thus my accounts are:
> 
> Expenses:Farm:RedCar:Gas,
> Expenses:Farm:Tractor1:Repairs,
> etc.
> 
> To adapt this for your chart of accounts you need to remember (a) that a 
> full stop in a regular expression means 'match any character', and to 
> match just a full stop you need to 'escape' it with a backslash '\' ; 
> and (b) that regular expressions are case sensitive.  Therefore this 
> expression should (I hope) work for you:
> 
> farm\..+\.[^gr]
> 
> or failing, try this:
> 
> farm\.[^.]+\.[^gr]
> 
> 
> I said that this was a 'hacky' workaround, but given 26 upper case 
> letters [A-Z] and 26 lower case letters [a-z] plus 10 digits [0-9] a 
> careful, if slightly clunky, account naming convention could deliver you 
> a workable and very flexible solution with up to 62 distinct child 
> accounts.
> 
> I hope this all makes sense ;--)
> 
> In passing I also note that there *is* an option to negate the 
> Transaction Filter - but this probably doesn't suit your needs.
> 
> Regards
> 
> Geoff
> =====
> 
> 


More information about the gnucash-user mailing list