question

JorisDriepinter-4332 avatar image
0 Votes"
JorisDriepinter-4332 asked Ehren answered

Custom comparer in Power Query

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?





power-query-not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Ehren avatar image
0 Votes"
Ehren answered

Hi there. Power Query is no longer supported here on Q&A. Please post your question over on https://aka.ms/PQCommunity instead.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.