Decode escape characters

aurbanska · ‎02-25-2022

Hi,

is there a way in power query to decode escaped characters in order to see the text with special characters from different languages (e.g. instead of "\u00F3n" to see "ó")?

I am using MySQL data source.

Thank you!

V-lianl-msft · ‎03-01-2022

Hi @aurbanska ,

Please check the blog to escape special characters.

https://blog.crossjoin.co.uk/2018/03/05/character-escape-sequences-in-m/

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

aurbanska · ‎02-28-2022

Hi

Thank you for replying!

This is the sample data that I am getting directly from MySQL and that includes escape characters (Description column):

lbendlin · ‎02-26-2022

Normally you specify the encoding during the import from the data source, and Power Query does the rest automatically. It's not entirely clear which way you want to convert. Can you provide some sample data that are equivalent to what MySQL gives you?