How to remove accents from a column using Power Query?

[webportal]

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?

[Anonymous]

Please try this:  https://stackoverflow.com/q/71969831/6165594

= (textToConvert) =>
let 
    textBinary = Text.ToBinary  (textToConvert,              1251 ),
    textASCII  = Text.FromBinary(textBinary   , TextEncoding.Ascii)
in    
    textASCII

[eduardobonfim]

Simple, Quickly and Bealtiful...Congratulations

[jdusek92]

Very quick elegant solution, works for me, should be marked as the solution as well!

[harshnathani]

Hi @webportal ,

https://community.powerbi.com/t5/Desktop/Replacing-Letters-with-Accents/td-p/569615#:~:text=Re%3A%20...

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)

[harshnathani]

HI @webportal ,

Check if this helps.

[Anonymous]

Sorry, a bit off topic...

But how did you attach .pbix file to post? 🤔
Here is the branch for this topic. 🙂

[Fowmy]

@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 🙂

YouTube, LinkedIn

[lkalawski · Accepted solution]

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