[GNC] filtering in report

[Adrien Monteleone]

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
> gnucash-user at 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.
>