Home > OS >  Power Query: how to remove diacritic/accent symbols from text
Power Query: how to remove diacritic/accent symbols from text

Time:04-25

How to remove diacritic/accent symbols from text in Power Bi / Power Query ?

Example:

Convert this: 'ÀÁÂÃÄÅàáâãäåÒÓÔÕÕÖØòóôõöøÈÉÊËèéêëðÇçÐÌÍÎÏìíîïÙÚÛÜùúûüÑñŠšŸÿýŽž'
to this:      'AAAAAAaaaaaaOOOOOOOooooooEEEEeeeeeCcDIIIIiiiiUUUUuuuuNnSsYyyZz'

CodePudding user response:

Please create & try the following function:

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

Diacritic symbols removal example

  • Related