STARTSWITH()

Does text begin with fragment?

Returns a Yes/No value as follows:

  • TRUE if the text fragment is found at the beginning of the search value.
  • FALSE if the text fragment is not found at the beginning of the search value.

Note: The search is case-insensitive: upper- and lower-case letters are equivalent.

Sample usage

STARTSWITH("aBc", "a") returns TRUE

STARTSWITH("aBc", "bc") returns FALSE (Bc occurs, but not at the beginning)

STARTSWITH("aBc", "D") returns FALSE (D does not occur)

STARTSWITH("I'm bored!", "Red") returns 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)

  • haystack - Any text value in which the text fragment (needle) is to be sought.
  • needle - Any text fragment to find in search value (haystack).

See also

ENDSWITH()

FIND()

IN()

LEFT()

RIGHT()

 

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false