Regular expressions in GnuCash

[David T.]

Derek,

I know that the Number column isn’t stored as a number (although I don’t think it got raised in this particular thread before you did here); that is why I don’t plan to file an RFE, since it would entail a restructuring of the data format. Well, that, and the fact that this particular need is not one that I encounter in my own use of GnuCash.

It is unfortunate that the field is set up as text rather than a numeric—but I understand the reasoning. It is too bad that this decision has made it so difficult for this use case.

David

> On Sep 24, 2016, at 10:33 PM, Derek Atkins <derek at ihtfp.com> wrote:
> 
> Larry,
> 
> On Sat, September 24, 2016 12:52 pm, Larry Evans wrote:
>> On 09/24/2016 05:16 AM, Liz wrote:
>>> On Sat, 24 Sep 2016 13:09:46 +0500
>>> "David T. via gnucash-user" <gnucash-user at gnucash.org> wrote:
>>> 
>>> 
>> David, maybe this "request for enhancement" could use libreoffice calc's
>> Standard Filter as a starting point.  This Standard filter allows
>> selecting columns and criteria on those columns joined by And or Or
>> logical operators.  An example is attached.  The example shows filter
>> to select check no. between 1000 and 1200.
> 
> The problem is that the "Number" column isn't a numeric data field.  It's
> a free-form string.  So what does ">=" "1000" mean when the input is
> FooBar?
> 
> You'll note that the search dialog *IS* very similar to the graphic you
> posted.  The main difference here is that, as I (and others) have said: 
> The "Num" column is a string, not a number, so the search provides string
> functions, not numeric functions.
> 
>> HTH.
>> 
>> -regards,
>> Larry
> 
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> -derek
> 
> -- 
>       Derek Atkins                 617-623-3745
>       derek at ihtfp.com             www.ihtfp.com
>       Computer and Internet Security Consultant
> 
> _______________________________________________
> 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.