Text.Contains

Text.Contains
Returns whether the text contains the substring.
function (optional text as nullable any, substring as text, optional comparer as nullable function) as nullable any
Description
Detects whether the text text contains the text substring. Returns true if the text is found.  comparer is a Comparer which is used to control the comparison. Comparers can be used to provide case insensitive or culture and locale aware comparisons.  The following built in comparers are available in the formula language:    
Category
Text.Membership
Examples
Find if the text "Hello World" contains "Hello".
Text.Contains("Hello World", "Hello")
true
Find if the text "Hello World" contains "hello".
Text.Contains("Hello World", "hello")
false

Text.Combine

Text.End

Last modified 4yr ago