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

ENDSWITH

Returns true if a property or string ends with a value, and returns false otherwise.

Syntax

=ENDSWITH(value, test)

Arguments

ArgumentTypeDescription
valueStringThe value to check for the ending string
testStringThe value to look for

Examples

=ENDSWITH("xyz", "x")false
Tests whether the string "xyz" ends with "x".

=ENDSWITH("xyz", "a")false
Tests whether the string "xyz" ends with "a".

=ENDSWITH("xyz", "z")true
Tests whether the string "xyz" ends with "z".

=ENDSWITH(@"Property 1", "abc")false
Tests whether the shape data property @"Property 1" ("abcdef") ends with the string "abc".

=ENDSWITH(@"Property 1", "def")true
Tests whether the shape data property @"Property 1" ("abcdef") ends with the string "abc".