[GNC] regex search

Derek Atkins derek at ihtfp.com
Thu Feb 24 07:38:35 EST 2022


Hi,

The other regex you could use is:
   .+
which means "match anything with at least one character"

If you want to match only numbers, you can use:

   [0-9]+

-derek

On Wed, February 23, 2022 9:54 pm, Geoff wrote:
> 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 at 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.
>


-- 
       Derek Atkins                 617-623-3745
       derek at ihtfp.com             www.ihtfp.com
       Computer and Internet Security Consultant



More information about the gnucash-user mailing list