CONTAINS()

Does text contain fragment?

Returns a Yes/No expression, as follows:

  • TRUE if the text fragment is found in the search value.
  • FALSE if the text fragment is not found in the search value.

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

Examples

CONTAINS("abc", "a") returns  TRUE

CONTAINS("abc", "bc") returns TRUE

CONTAINS("abc", "d") returns FALSE

CONTAINS("I'm bored!", "Red")  returns TRUE

CONTAINS([Address], "PO Box") answers the question: does the Address indicate a post office box?

CONTAINS([Email], "@") answers the question: does the Email contain at least one at sign (@)?

CONTAINS(".?!", LEFT([Sentence], 1)) answers the question: is the left-most character of the value of the Sentence (LEFT([Sentence], 1)) a period (.), question mark (?), or exclamation mark (!) (".?!")? Equivalent to IN(LEFT([Sentence], 1), {".", "?", "!"}).

See also: LEFT(), IN()

Syntax

CONTAINS(haystack, needle)

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

See also

ENDSWITH()

FIND()

IN()

STARTSWITH()

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