Forum Discussion
Decode escape characters
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!
3 Replies
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?
Hi
Thank you for replying!
This is the sample data that I am getting directly from MySQL and that includes escape characters (Description column):
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.
