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