Forum Discussion
Encode/Decode text
Dear Friend,
Could you please help, how we can encode column with cp1252 and then decode with cp1256
Hi jyaul12 ,
Please try to use power query and transform data like this:
Text.FromBinary( Text.ToBinary([Column1],1252),1256 )Refer to:
Solved: Problem with special character encoding (Possibly ... - Microsoft Power BI Community
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi jyaul12 ,
Please try to use power query and transform data like this:
Text.FromBinary( Text.ToBinary([Column1],1252),1256 )Refer to:
Solved: Problem with special character encoding (Possibly ... - Microsoft Power BI Community
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, seeing your answer I was inspired to solve my problem. I wrote a command like this:
= Json.Document(Text.ToBinary(Text.Replace(Text.FromBinary(File.Contents("C:\20230921_113447\Profit.txt")),"client-value-update:","")))
Have a nice day.
