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: