Forum Discussion
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'Érablière |
| École Saint-Jean-De-Brébeuf |
| École Secondaire De L'Île |
Can anyone suggest me how to convert them in simple english language using power query.
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
6 Replies
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
Why on earth would you want that?
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 ...
