Removing Diacritics From Text In Power Query
Chris Webb BI
FEBRUARY 26, 2023
I faced an interesting challenge recently: I had to use Power Query to remove all non-ASCII characters from some text but maintain the readability of that text. Let’s take the French phrase “un garçon très âgé à Noël” (which I know doesn’t make much sense but is great for testing) as an example. If you remove everything apart from the basic latin alphabet characters and spaces using Text.Select as I blogged here : Text.Select( "un garçon très âgé à Noël", List.Combine( {{
Let's personalize your content