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.

See Also

ENDSWITH(), FIND(), IN(), LEFT(), RIGHT()

Did this answer your question?