Contains
- 19 May 2022
- 1 Minute to read
-
DarkLight
-
PDF
Contains
- Updated on 19 May 2022
- 1 Minute to read
-
DarkLight
-
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?