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:

Related functions


Was this page helpful?
Yes No