The good news is negate search (both simple substring and regex) will be available on transaction-report based reports for 3.8 onwards due early January.
Or you could try a recent build on https://code.gnucash.org/builds/win32/maint/ -- these should have a bunch of recent fixes, and no known regressions. On Mon, 11 Nov 2019, 08:52 Fran_3 via gnucash-user, < gnucash-user@gnucash.org> wrote: > 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 < > adrien.montele...@lusfiber.net> 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 < > gnucash-user@gnucash.org> 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 > gnucash-user@gnucash.org > 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 > gnucash-user@gnucash.org > 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 gnucash-user@gnucash.org 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.