ENDSWITH

From AgileApps Support Wiki
Revision as of 00:52, 4 June 2014 by imported>Aeric
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

The ENDSWITH function determines whether a target string ends with a specified search string. This function returns TRUE if the target string ends with the search string. If the target string does not end with the search string, this function returns FALSE.

Syntax
ENDSWITH('string', 'searchString')

Notepad.png

Note:
The searchString is case-sensitive. For a case-insensitive search,
use the LOWER function on both the search string and the string being searched.

Return
TRUE or FALSE
Examples
ENDSWITH('john@stop.com', '.com') = TRUE
ENDSWITH('john@stop.net, '.com') = FALSE