[GNC] How to do a couple of less common searches

David Carlson david.carlson.417 at gmail.com
Tue Jul 5 01:00:17 EDT 2022


TY Geoff,

Your answer to 1. works nicely.
That is a nice reference for 2.
As for 3, GnuCash now allows imports without a transfer account if the
value is zero, which I don't like, so I try to catch them on the way in,
but I may miss some.

On Mon, Jul 4, 2022 at 11:17 PM Geoff <cleanoutmyshed at gmail.com> wrote:

> Hi David
>
> 1. See screenshot.  Explanation:
> "^" means start of field
> "." means match any character
> "DOES NOT match regex" means find all transactions where the field DOES
> NOT have any character(s) ie is blank.
> "Any criteria are met" means an OR search - only 1 of the criteria
> (Number or Notes) needs to be met.
> - Hope this makes sense.
>
> 2. I have no idea, but you may find this guide to "POSIX" Regular
> Expressions (the dialect used in GnuCash) useful:
>
> https://www.ibm.com/docs/en/watson-explorer/11.0.1?topic=queries-posix-regular-expression-syntax-examples
>
> 3. I don't understand what you mean by "no transfer account" - don't all
> transactions have to have at least 2 splits?
>
> NOTE that you can also View / Sort By an account by various fields
> including Number, Amount, Notes etc which may help you to identify the
> transactions that you are after.
>
> Regards
>
> Geoff
> =====
>
>
> On 5/07/2022 1:54 pm, David Carlson wrote:
> > Every so often I want to search for misteaks in my data, and some less
> > usual searches come to mind.  Can someone help  me with these?
> >
> > 1. All transactions in the current account with nothing in the Number box
> > or in the Notes box.
> >
> > 2.  Where in the help is a clue to doing a Regex based search that us
> > non-coders can understand?
> >
> > 3.  All transactions that have both zero value and no transfer account.
> >



-- 
David Carlson


More information about the gnucash-user mailing list