In Power Query I like to write a custom comparer function, for instance:
Text.Contains("abc","abc", (s,t)=>Comparer.Ordinal(s,t)).
This results in an error message:
Expression.Error: The specified comparer does not support culture sensitive comparisons.
I cannot find any documentation for this error or how to resolve it.
Is it even possible to create a custom comparer for a function like Text.Contains or does it only support built-in comparers?