[GNC] Transaction Report Filter for keyword in Description ?
Fran_3
mailbox0600 at yahoo.com
Mon Sep 21 17:33:05 EDT 2020
I think the implied meaning of "Account" got me confused...
Transaction Report - Accounts Tab:I selected the "Account" via the Accounts Tab to be...
"Assets > Current Assets > Checking Account"
Transaction Report - Filter Tab - Account Name Filter field:
Is the "Account Name Filter" field expecting the name of an Expense Account... or Income Account... that the Checking transaction was charged to?
Transaction Report: - Filter Tab - Transaction Filter field:Regular Expressions... Rats!Rant...I can, more or less, program in a number of languages... Assembly Language, Basic, Visual Basic, Visual Basic for Applications, HTML, Java Script, PHP, Active Server Pages, SQL... plus on rare occasions Python, C, & C++ and a few more more...But, that said, I will do almost anything to avoid Regular Expressions.Can I do it... sure if I take the day off to refresh myself and then hack, hack, hack, and groan, groan, groan.Rant finished.Sorry. Not Sorry.
In this case my Keyword string may have any case letters, anywhere in it... and it may have a punctuation mark before or after it... like...WebsiTenAme.cOm
Anyway, thanks for the help John... I was moving so fast to get done that I skipped right over the obvious... Too. Tips.
On Monday, September 21, 2020, 12:43:05 PM EDT, John Ralls <jralls at ceridwen.us> wrote:
> On Sep 21, 2020, at 8:57 AM, Fran_3 via gnucash-user <gnucash-user at gnucash.org> wrote:
>
> How can I create a Transaction Report for the Check Register...
> set to only display transactions where a keyword appears in the Description field?
> I'm confused by the "Account Name" Filter and the "Transaction Filter" fields...
>
> Thanks for any help.
Even after reading the tooltips? (Hover your pointer over each field.)
Summarizing them, use the Accounts filter to select from which accounts to select the transactions and the transactions filter to select which transactions based on the entered string or regular expression [1] matching the transaction description or notes, or a split memo.
Regards,
John Ralls
[1] https://en.wikipedia.org/wiki/Regular_expression
More information about the gnucash-user
mailing list