Examples
STARTSWITH("aBc", "a")
: TRUE
STARTSWITH("aBc", "bc")
: FALSE (Bc
occurs, but not at the beginning)
STARTSWITH("aBc", "D")
: FALSE (D
does not occur)
STARTSWITH("I'm bored!", "Red")
: FALSE (red
occurs, but not at the beginning)
STARTSWITH([Email], "noreply@")
answers the question: does the Email contain an address to which messages shouldn't be sent? Functionally equivalent to but more efficient than ("noreply" = ANY(SPLIT([Email], "@")))
. See also: ANY(), SPLIT().
Syntax
STARTSWITH( haystack , needle )
Arguments
haystack (any) : The text value in which the text fragment (needle) is to be sought.
needle (any) : The text fragment to find in search value (haystack).
Return Value
Yes/No : TRUE if the fragment (needle) is found at the beginning of the search value (haystack). Note that the search is case-insensitive: upper- and lower-case letters are equivalent.