CODEWITHSUNDEEP
functiontextpowerbipowerquerydiacritics
Denis
Denis

Reputation: 781

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

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

Example:

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

Upvotes: 1

Views: 7761

Answers (1)

Denis
Denis

Reputation: 781

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

Upvotes: 7

Related Questions