DOESNOTCONTAIN

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

Syntax

=DOESNOTCONTAIN(haystack, needle)

Arguments

Argument	Type	Description
haystack	String or Array	The value to look for the needle in
needle	Any	The 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").