Problem in removing accent

[Vidushi_Mangal]

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.

[Anonymous · Accepted solution]

@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

[AbhinavJoshi · Accepted solution]

Please refer to this post 
https://community.fabric.microsoft.com/t5/Desktop/How-to-remove-accents-from-a-column-using-Power-Qu...

[PwerQueryKees]

Why on earth would you want that? 

[Vidushi_Mangal]

Because I want to live my own world ...

[Anonymous]

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.

[Anonymous · Accepted solution]

@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