Contains
The function Contains returns true
if a string contains specified substring(s); otherwise, returns false
.
Contains is case-sensitive. To create a search that is not case sensitive, you can combine Lower with Contains.
Contains takes 2 or more arguments, depending on the number of
Contains is part of Sigma's Text functions.
Syntax
Contains(string, substring_1, ...)
The Contains function has the following arguments:
- string
- Required
- The text to search
- substring_1
- Required
- The text to find inside the string
- substring_2 ... substring_n
- Optional
- Additional text to find inside the string
Examples
Contains("Jane Doe", "ne D")
Returns TRUE
Contains(Lower("Jane Doe"), "ne d")
Returns TRUE
Contains(Lower("Jane Doe"), "ne d", “b”)
Returns TRUE
Contains(Contains([Product Name], "Black")
Contains([Product Name], "Black", "Blue")
Returns the following values for the query: