Forum Discussion
Solved
How to remove accents from a column using Power Query?
How to remove accents from a column using Power Query? My column "descritivo" has a lot of accentuated characters, like: "Á" "õ" "Ù" ... I want: "A" "o" "u" How to do this?
Hi webportal ,
You can do this by using R in Power Query.
Please check this link: http://datacornering.com/how-to-convert-accented-characters-to-unaccented-in-r-or-power-bi/
_______________
If I helped, please accept the solution and give kudos! 😀
Please try this: https://stackoverflow.com/q/71969831/6165594
= (textToConvert) =>
let
textBinary = Text.ToBinary (textToConvert, 1251 ),
textASCII = Text.FromBinary(textBinary , TextEncoding.Ascii)
in
textASCII
Simple, Quickly and Bealtiful...Congratulations