These docs are for v1.0. Click to read the latest docs for v1.2.

DOESNOTCONTAIN

Returns true if a property or string does not contain a value, and returns false otherwise.

Syntax

=DOESNOTCONTAIN(haystack, needle)

Arguments

ArgumentTypeDescription
haystackString or ArrayThe value to look for the needle in
needleAnyThe value to search for in the haystack

Examples

=DOESNOTCONTAIN("xyz", "x")false
Tests whether the string "x" is contained in the string "xyz".

=DOESNOTCONTAIN("xyz", "a")true
Tests whether the string "a" is contained in the string "xyz".

=DOESNOTCONTAIN("xyz", "vxyz")true
Tests whether the string "vxyz" is contained in the string "xyz".

=DOESNOTCONTAIN(@"Property 1", "abc")false
Tests whether the string "abc" is contained in the shape data property @"Property 1" ("abcdef").