Contains
  • 19 May 2022
  • 1 Minute to read
  • Dark
    Light
  • PDF

Contains

  • Dark
    Light
  • PDF

Returns true if the given text contains the given slice of text, otherwise returns false.

Function signature

CONTAINS(text: String, pattern: String) => Boolean
Parameter Description
Text Text to test
Pattern Slice of text to find

Examples

Formula Return value
CONTAINS("Foo Bar", "Foo") true
CONTAINS("Foo Bar", "foo") false
CONTAINS("Foo Bar", "o B") true

Was this article helpful?