Forum Discussion
Problem in removing accent
- Anonymous2 years ago
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
- 2 years ago
Please refer to this post
https://community.fabric.microsoft.com/t5/Desktop/How-to-remove-accents-from-a-column-using-Power-Query/td-p/1314898
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