Text.Contains
Returns whether the text contains the substring.
function (optionaltext
as nullable any,substring
as text, optionalcomparer
as nullable function) as nullable any
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: Text.Membership
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
Last modified 4yr ago