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
=====
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
