Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 ...
Need Help
  • Hauke's avatar
    Hauke
    7 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

 

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

 

 

DanielCooper's avatar
DanielCooper
Regular Visitor
2 years ago

Hello Denis,

 

I was hoping you'd be able to help me

 

Is there a different version of encoding I can use to help me convert the below:

 

From: Rvt Tekstil Konfeksiyon Sanayi Ve Dış Ticaret Ltd Åžti

To: Rvt Tekstil Konfeksiyon Sanayi Ve Dış Ticaret Ltd Şti

 

The target language is Turkish

 

Any help you can offer would be greatly appreciated

 

Thank you,

 

Daniel