Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good evening,
Can someone point me in the right direction? I'm trying to include an exclamation mark using the UNICHAR function but I'm obviously doing something wrong:
Is there a library somewhere with the correct UNICODEs? the one I'm using is rendering the wrong symbol.
Thanks,
Paul.
Proud to be a Super User!
Paul on Linkedin.
Solved! Go to Solution.
UNICHAR expects decimal codes. Your information contains hexadecimal codes.
Hex 2757 = Decimal 10071.
You can find a conversion function in the link below this video (the link starts at the point where the function is explained).
This is how the function can be used to convert "2757" from hexadecimal to decimal:
= fnNumberBaseConversion("2757", 16, null)
Thank you Marcel for the explanation and video!
EDIT: I've been looking around and found an online conversion tool if anyone is interested:
https://www.binaryhexconverter.com/hex-to-decimal-converter
Proud to be a Super User!
Paul on Linkedin.
UNICHAR expects decimal codes. Your information contains hexadecimal codes.
Hex 2757 = Decimal 10071.
You can find a conversion function in the link below this video (the link starts at the point where the function is explained).
This is how the function can be used to convert "2757" from hexadecimal to decimal:
= fnNumberBaseConversion("2757", 16, null)
Thank you Marcel for the explanation and video!
EDIT: I've been looking around and found an online conversion tool if anyone is interested:
https://www.binaryhexconverter.com/hex-to-decimal-converter
Proud to be a Super User!
Paul on Linkedin.
By the way, you may help accept the solution above. Your contribution is highly appreciated.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |