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
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
Sure, I am genuinely curious thiugh. And there may be an underlying problem that can better be solved.