Re: [GNC] filtering in report

2022-02-09 Thread Andreas Hentze
Hi Geoff, I think that the logical complement of this is: (See https://en.wikipedia.org/wiki/De_Morgan%27s_laws) NOT Second-Last character is 'u' AND NOT Second-Last character is 'o'  OR NOT Last character is 'b' AND NOT Last character is 'r' Which, as a regular expression, is:

Re: [GNC] filtering in report

2022-02-08 Thread 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

Re: [GNC] filtering in report

2022-02-08 Thread Andy
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

Re: [GNC] filtering in report

2022-02-07 Thread Geoff
Hi Andy You said: > Next step is trying the complement: "[^uo][^br]$" > But this does not work as "Anzeiger" ist although filtered out. Because you are anchoring the pattern match to the end of the account name (with the '$'), and specifying two character classes (with the '[]') this pattern

[GNC] filtering in report

2022-02-05 Thread Andreas Hentze
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