Regular expressions in GnuCash
wm_o_o_o at yahoo.co.uk
Tue Oct 18 09:39:13 EDT 2016
On 25/09/2016 08:03, John Ralls wrote:
>> On Sep 25, 2016, at 8:20 AM, David T. via gnucash-user <gnucash-user at gnucash.org> wrote:
>> 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.
> The use-case was to list all of the checks a user wrote since 1 Jan 2015. It somehow drifted off to writing a regex to match a particular set of numbers. That's not necessary for the use case because one can search for "Date Posted is on or after 1 Jan 2015 and Number matches regex [0-9]+", assuming that the user marked only and all check transactions with numerics in the Number field. Since the original poster's eyes glazed over early on in the regex discussion no one really probed what his practices were.
Further, anyone that follows this list will know that people put all
sorts of things other than cheque numbers in the field. Not surprising
when many of us don't use cheques at all!
It is just a convenient free form text field
More information about the gnucash-user