Search options for Number field treat it as a string, not a number

[prl]

On 10/05/13 21:34, David Carlson wrote:
> On 5/10/2013 2:55 AM, Michael Hendry wrote:
>> ...
>>
>> I thought I should be able to use Edit=>Find and select Number >=117894 (for example)  to find out if the top receipt was the most recently numbered transaction, but the options are "contains", "matches regex" and "does not match regex".
>> ...
>>
> If you go to the trouble to learn about regular expressions and how to
> use them, you can learn how to build a query equivalent to "any number
> greater than 2000", for example.  However, I am an old fogey that does
> not know how to do it.  There are many good references on the Internet.
>
> David C
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
I thought it was *only* old fogies who knew how to use regular 
expressions :). Anyway, an RE to match only numbers greater than another 
arbitrary number can get a bit messy. Even "greater than 2000" is a bit 
nasty, though something like 
[0-9][0-9][0-9][0-9][0-9]+|[3-9][0-9][0-9][0-9]|2[0-9][0-9][1-9]|2[0-9][1-9]0 
should do it. "Greater than some arbitrary number" is fairly hard.

An RE for "Greater than or equal to 117894" is left as an exercise for 
the reader.

Numerical comparisons for numerical values would be a good deal easier.

Peter