Is there an existing issue or pull request for this?

• I have searched the existing issues and pull requests

Feature description

There are situations where an "exclude" operator that basically behaves as the inverse of the include match operator ' instead of the inverse of the exact match operator !

I lets say I want to exclude matches a portion of a string. I don't see any way to achieve this with the current operators.

Current operators let me exclude only full matches not portions of string matches.

The include ' works how I would expect = to work in that a if the search string exists anywhere in the search keys it shows as a match. The = doesn't seem to consider it a match unless the search key is exactly equal to the search.

The inverted ! works by excluding the exact matches where the search key cannot be exactly the inverted search term. This will not work for inverting partial string matches and I don't see any operator that currently supports inverting the include operator.

Desired solution

Please add an inverted-include operator possibly like: !'

Alternatives considered

possible a different operator could be used for this or change the ! operator to be a little more loose so that in can invert partial string (include) matches.

Additional context

Say you have a dataset like:

[ "test1","example1"]

I want to search with something like "!'xam" and get a result like ["test1"]

currently a search of "!xam" results in something like [ "test1","example1"] since it isn't an exact match to anything.