Re: [GNC] regex search

2022-02-24 Thread Derek Atkins
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 sh

Re: [GNC] regex search

2022-02-23 Thread Geoff
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 explana

[GNC] regex search

2022-02-23 Thread Jeff
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