Forum Discussion
Solved
sort zero length text strig power query v excel
Hello i wanted a custom sort so sort N, S, E, W order by adding zero length text , but i have found the order seems to get reversed, if done purely in excel sorting is shortest to lon...
They are different programs with different sorting algorithms. As to why they were designed differently with regard to zero-width characters, you would have to discuss that with the teams that developed the two different programs. There are other parameters that are also sorted differently by those two programs.
just to add i did find this ;
Power Query uses binary Unicode ordering, not Excel’s “soft whitespace” rules.
That is the default for Power Query, but you can use the optional `comparisonCriteria` argument to modify it in many ways (one way is as I showed in my work-around, but it is pretty flexible)