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 <[email protected]> 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 _______________________________________________ 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.
