Rule Engine Logic and the NOT command

Hi,

I am trying to use the Rule Engine node using LIKE and NOT together, but cannot get it to work. Any ideas most welcome. My best attempt which is not accepted is below;

 

$Col1$ LIKE "*Cats*" AND $Col1$ NOT LIKE "*Dogs*" => "There are Cats But No Dogs Here"

Thanks

 

Simon.

Hi Simon,

This should work:

$Col1$ LIKE "*Cats*" AND NOT $Col1$ LIKE "*Dogs*" => "There are Cats But No Dogs Here"

I am afraid the NOT LIKE form is not supported by the nodes. (In case Col1 is boolean, you might need to add parentheses around the second LIKE expression.)

Cheers, gabor

1 Like

Cheers Gabor,

I thought I had tried every permutation but obviously not. This works like a charm.

Thanks,

Simon.