The notcontains operator returns true if the value on the left does not contain the value on the right, false if it does.


This operator has two parameters:

value1 – The first numeric or text value.

value2 – The second numeric or text value.


The notcontains operator compares two values (usually text) to see if the value on the left does not contain the value on the right anywhere within it.

"abcdef" notcontains "abc" ☞ false
"abcdef" notcontains "xyz" ☞ true
12345 notcontains 234 ☞ false

As the final example shows, the notcontains operator can work with numbers as well as text – it simply automatically converts the number into text before comparing.

As a more practical example, the formula below will be false if the Address field or variable contains the letters box.

Address notcontains "box"

This formula will be false if the if the address is P.O. Box 5328, and true if the address is 6938 Wilson Road.

Note: The notcontains operator does not worry about upper or lower case, so P.O. BOX 5328 or p.o. box 5328 will also produce false results. If upper and lower case are important to you use the notmatchexact operator.

See Also


10.0UpdatedCarried over from Panorama 6.0, but also now allows numeric as well as text parameters.