I would like to run a query that $Keyword.format(“l”).icontains(“X”)ANDNOT$Keyword.format(“l”).icontains(“Y”)
I’m not sure what the symbol for ANDNOT should be.
I would like to run a query that $Keyword.format(“l”).icontains(“X”)ANDNOT$Keyword.format(“l”).icontains(“Y”)
I’m not sure what the symbol for ANDNOT should be.
X And Not Y
X & (not Y)
X & !(Y)
So
$Keyword.format("l").icontains("X") & !($Keyword.format("l").icontains("Y"))
The !(…)
syntax is not formal but uses a pair of parentheses to have clarity of what it is negating.