Adrian, Thanks for the response.
I have to admit I have done regular expressions... but I often tire of the
fight... as I ultimately did in this case.
My solution in this particular case was to port the gnuCash check register into
a spreadsheet and manipulate it from there to exclude the target entity and
ultimately get the desired result.
Fran3
PS - I did try running a Transaction Report on Checking and then hit Ctl F and
searched the Description for the entity name using the "does not match regex"
option... but the results were confusing to me...
Actually I was unsure if I should just enter the entity name in the "does
notmatch regex" search field...
or if I should enter a regular expression...
but just entering the entity name... Vendor X... didn't seem to return all
checking transactions except those to/from Vendor X.
On Sunday, November 10, 2019, 6:37:23 PM EST, Adrien Monteleone
<[email protected]> wrote:
You have two options, but both require a negative regex, which while possible,
might not be part of the regex library used by GnuCash. (I don’t know, you’d
have to try it out)
#1 - Transaction Report (as requested) with regex *not matching* a string in
the Filter field. (it will return transactions that do not match that string in
the Description, but also the Notes & Memo, which may or may not, be okay.)
#2 - Find, followed by Account Report - same regex expression, but with the
ability to *only* filter on the Description and not also the Notes and Memo
fields.
Which you use is up to you, or which one actually works at all. (if either)
Please do let us know if you manage this as I’m sure others would be interested.
Regards,
Adrien
> On Nov 10, 2019 w46d314, at 9:21 AM, Fran_3 via gnucash-user
> <[email protected]> wrote:
>
> I guess I suffering from project fatigue on this exercise as, all of a
> sudden, I cant run a Transaction Report on Checking and then exclude all
> transactions to a particular entity... Vendor X
> I thought I had done this before but... maybe not.
>
> Without grinding through all the attempts I've made this morning would some
> kind soul just tell me how to do this...
> And note... the entity name has two words in it... "Vendor X" in this
> example... both of which are necessary for unique identification.
> Thanks for any help. Fran3
_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
