This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Does not contain

Posted on 10-23-2020 03:46 PM
Tom_automated
New Member
Reply posted on --/--/---- --:-- AM

Is there an opposite for CONTAINS([City], โ€œCapitolโ€)? I need something that says does not contain Capitol, does not contain Town, does not contain, County

0 2 287
Topic Labels
0 Likes
2 REPLIES 2

Posted on --/--/---- --:-- AM
Chris_Jeal
Silver 3
Silver 3
Reply posted on --/--/---- --:-- AM

Try:

NOT(CONTAINS([CITY],โ€œCapitolโ€))

Posted on --/--/---- --:-- AM
Steve
Platinum 4
Platinum 4
Reply posted on --/--/---- --:-- AM

For reference:


Top Labels in this Space