Forum Discussion
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! 😀
8 Replies
Please try this: https://stackoverflow.com/q/71969831/6165594
= (textToConvert) => let textBinary = Text.ToBinary (textToConvert, 1251 ), textASCII = Text.FromBinary(textBinary , TextEncoding.Ascii) in textASCIIVery quick elegant solution, works for me, should be marked as the solution as well!
Simple, Quickly and Bealtiful...Congratulations
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! 😀webportal
You can use replace value in power query to do it one at a time like
For more values, follow this video that shows how to do it for bulk replacement.
https://www.youtube.com/watch?v=MLrRlPh_ZFQ________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
Hi webportal ,
http://datacornering.com/how-to-convert-accented-characters-to-unaccented-in-r-or-power-bi/
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
