textas nullable any,
substringas text, optional
compareras nullable function) as nullable any
textcontains the text
substring. Returns true if the text is found.
Comparerwhich 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: