[GNC] Regular Expressions in Reports

[Geoff]

Hello Grace

The Transaction Report Options screen has a "Filter" tab that lets you:

(a) Include (or exclude) Accounts by filtering on Account Name using:
(a.1) A simple string of characters (eg "tax").
or
(a.2) A regular expression - see below.

(a) Include (or exclude) Transactions by filtering on Description using:
(a.1) A simple string of characters (eg "tax").
or
(a.2) A regular expression - see below.


GunCash uses the "POSIX" dialect of regular expressions, and this 
document from IBM provides a good overview:

https://www.ibm.com/docs/en/watson-explorer/12.0.x?topic=queries-posix-regular-expression-syntax-examples

Thus:
^Tax means starts with "Tax"
^[Tt]ax means starts with "Tax" or "tax"
taxable$ means ends with "taxable"
202[0-3] means contains 2020, 2021, 2022, or 2023.

Do remember that regular expressions are CaSe sEnSiTiVe!


Hope this helps.

Geoff
=====

On 11/09/2024 2:14 am, Grace wrote:
> I'm forgetting everything I used to know.
> 
> Can someone point me to where I can find out how to filter by regular 
> expressions in the transaction report option.
> 
> Many thanks,
> 
> Grace.
> 
>