Forum Discussion
Solved
Problem in removing accent
I have a database which consist of values like École De La Forêt École Des Cavaliers École Du Lac-Des-Fées École Du Sacré-Coeur École Parc-De-La-Montagne École Polyvalente De L'Éra...
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
