Use the CONTAINS Function to Identify Substrings in Text

Description

Determines if a Text is included within another Text.

CONTAINS(Text to Find, Text to Search [, Starting Position to Search] [, Is Case Sensitive])

Argument	Type	Dimensions	Description
Text to Find (required)	Text	Any Dimensions	Text to find in the searched Text.
Text to Search (required)	Text	No Dimension or Dimensions of Text to Find	Text to search in.
Starting Position to Search (optional)	Integer	No Dimension or Dimensions of Text to Find	Position of the character to start the search in, in Text to Search
Is Case Sensitive (optional)	Boolean	No Dimension or Dimensions of Text to Find	Whether the search is done with case sensitivity. By default, the search is not case sensitive.

Type	Dimensions
Boolean	Dimensions of Text to Find

TRUE if Text to Find is in Text to Search.

FALSE if Text to Find is not present in Text to Search.

BLANK if Starting Position to Search is a negative value or 0.

Formula	Result	Description
`CONTAINS(“a”, “abc”)`	`TRUE`	The Text “a” is present in “abc”.
`CONTAINS(“c”, “abc”)`	`TRUE`	The Text “c” is present in “abc”.
`CONTAINS(“A”, “abc”)`	`TRUE`	The search is not case sensitive by default. Finding the Text “A” is equivalent to finding the Text “a”.
`CONTAINS(“A”, “abc", 1, TRUE)`	`FALSE`	The search is case sensitive. “A” is not present in “abc”.
`CONTAINS(“a”, “abc”, 2)`	`FALSE`	The Starting Position to Search is set to 2. The searches the Text “a” from the Text “bc”.
`CONTAINS(“a”, “abc”, 0)`	`BLANK`	The Starting Position to Search, 0, is invalid.
`CONTAINS(“a”, “abc”, -1)`	`BLANK`	The Starting Position to Search, -1, is invalid.