Forum Discussion
Problem in removing accent
cwebb posyrd this gem a while back:
https://blog.crossjoin.co.uk/2023/02/26/removing-diacritics-from-text-in-power-query/
(inputText as text) as text => let ReplaceDiacritics = Text.FromBinary(Text.ToBinary(inputText, 28597), TextEncoding.Ascii), RemoveQuestionMarks = Text.Replace(ReplaceDiacritics, "?", " "), RemoveExcessSpaces = Text.Combine( List.RemoveItems(Text.Split(Text.Trim(RemoveQuestionMarks), " "), {""}), " " ) in RemoveExcessSpaces
--Nate
Super UserWhy on earth would you want that?
We try to help folks with their questions, not the quality of the question as perceived by us. People come up with new ways to use Power Query every day, in ways you nor I ever thought to use it.
--Nate
- PwerQueryKees
Sure, I am genuinely curious thiugh. And there may be an underlying problem that can better be solved.
Because I want to live my own world ...
