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! 😀
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 🙂