Syntax
Text.Contains(text as nullable text, substring as text, optional comparer as nullable function) as nullable logical
Description
Detects whether the text text contains the text substring. Returns true if the text is found.
Reference Data
https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference