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").
Updated 9 months ago