Hi Jeff
Here are two regular expressions (regex) for you:
^$
This should match an empty field: ^ = Start of field, $ = End of field.
^0
This should match anything with a leading zero.
Don't forget to select the Number field in the Find dialogue box.
And this web site has a reasonable explanation of the POSIX style used
by GnuCash:
https://www.ibm.com/docs/en/watson-explorer/11.0.1?topic=queries-posix-regular-expression-syntax-examples
Good luck!
Geoff
=====
On 24/02/2022 1:38 pm, Jeff wrote:
I'll admit right off the bat that I have trouble with regex expressions.
I find myself needing to be able to do 2 different searches.
1) find in the Num column if it is empty. Meaning that I or the
financial institution forgot to say put a check number or transaction id
(or type) in the field.
2) find in the Num column if it contains data. Most of my institutions
record a check number, ach etc, but put leading 0' (zeros), or other id
information, in the field. I need to search for those and remove the
extraneous characters and/or put in the proper type of transaction id.
I am at my wits end on figuring out how to do these searches. Would
someone please show me the proper search filter to do each of these?
_______________________________________________
gnucash-user mailing list
gnucash-user@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.
