Forum Discussion
Replacing Letters with Accents
Hi, I have two lists of names that I want to merge. One list used their names with accents (like é) and the other doesn't. Since having the proper names with the accents isn't super important, I ...
Hey Sean,
probably it is more complicated and I just don't get it because of languages reasons: I would just use the "Replace Values..." in the power bi "edit queries mode". Just right click on "René" > Replace Values. You can even choose columns and just replace é to e.
BR
or this:
https://docs.microsoft.com/en-us/powerquery-m/text-replace
you can use:
New column = Text.Replace([column name] , "á", "a")