Text.Contains
Syntax
Text.Contains(text as nullable text, substring as text, optional comparer as nullable function) as nullable logical
About
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:
Comparer.Ordinal
: Used to perform an exact ordinal comparisonComparer.OrdinalIgnoreCase
: Used to perform an exact ordinal case-insensitive comparison-
Comparer.FromCulture
: Used to perform a culture aware comparison
Example 1
Find if the text "Hello World" contains "Hello".
Text.Contains("Hello World", "Hello")
true
Example 2
Find if the text "Hello World" contains "hello".
Text.Contains("Hello World", "hello")
false