I'm not 100% certain, but investigate Regex 'look behind'. I seem to
recall using it for negation effectively but it has been some time.
Another option is to do a Find (always from the Accounts tab) and there
you can do Regex and/or 'does not match' type criteria for exclusions.
Then run an Account Report on the search results.
Unfortunately, there is no way to save search criteria so you'll have to
set that up every time you want the report.
Regards,
Adrien
On 2/6/22 12:27 AM, Andreas Hentze wrote:
Hello,
I'm struggling in a report. I hav a lot of expense and earning accounts.
In the "Buchungsbericht" is a tab named "Filter".
Lets have for example this accounts:
...farm.redcar.gas
...farm.redcar.repair
...farm.redcar.insurance
...farm.tractor1.gas
...farm.tractor1.repair
...farm.tractor1.insurance
using as regular expression filtering with "(gas|repair)" is working fine.
But how is it possible to get the complement. i.e. all expense and
earning accounts NOT have gas and repair in the account name?
"NOT (gas|repair)" and "!(gas|repair)" dos not work.
How shall the regEx be formulated?
And: It would be very helpful, if the filtering does not filter only the
name, but the description too! Then it would be easy to manage tags for
the accounts.
And 2: It would be very helpful, to have this filter tab in the profit
and loss report too.
best ragrds
Andy
_______________________________________________
gnucash-user mailing list
[email protected]
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.
_______________________________________________
gnucash-user mailing list
[email protected]
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.
