article How to find a number for a char: chr() and ord() functions in Member Articles

How to find a number for a char: chr() and ord() functions

SergeyMak — Wed, 30 Nov 2022 06:19:23 GMT

Everyone knows that sometimes we need to use chr() function to put paragraph sign - chr(13) – or single-quote - chr(39).

But sometimes you need a special symbol, but you don’t know the number. You can find it in the Internet, but I’ve found a Qlik way how to do it.

Just create a straight table.
Add Calculated Dimension =ValueLoop(1,100) or even =ValueLoop(1,10000)
Add Expression chr(RowNo())
And find a symbol that you need.

There is a faster way, If you found a symbol in the Internet and would like to know what is the number for this char.

For example delta sign

Use the ord() function

Ord(‘Δ’) gives you 916. So if you need to put this symbol somewhere you can use chr(916)

Some interesting codes are

=chr(9650) & chr(9651) & chr(9660) & chr(9661)

=chr(9733) and =chr(9734)

Be aware!

in the comments in different discussion jaimeaguilar mentioned that

"using chr() function you can display any ASCII / ANSI character (from chr 0 to 255) or Unicode chars (from chr 256 and up). The corresponding number in chr() function for the Unicode chars is the number referred as decimal, that can be found in plenty internet sites. Almost any Unicode char will display in ajax, but in some cases the correct displaying will depend on the page encoding."

Re: How to find a number for a char: chr() and ord() functions

mato32188 — Fri, 24 Apr 2015 07:07:46 GMT

Very simple and clever solution. Appreciate!

Re: How to find a number for a char: chr() and ord() functions

mithilesh17 — Fri, 24 Apr 2015 15:05:03 GMT

Very interesting n dependable solution in tricky situations.. Thanks!

Re: How to find a number for a char: chr() and ord() functions

rteco0131 — Wed, 29 Apr 2015 21:33:47 GMT

it's fantastic. Thanks!

Re: How to find a number for a char: chr() and ord() functions

Anil_Babu_Samineni — Wed, 03 Aug 2016 13:47:31 GMT

Good Job !!

But, I want to show like a square how to show that?

Re: How to find a number for a char: chr() and ord() functions

SergeyMak — Thu, 04 Aug 2016 10:31:45 GMT

Hi Anil,

to get to know you just need to use this solution.

Try to use =ValueLoop(1,10000) as a dimension and you will find the answer soon.

Regards,

Sergey

Re: How to find a number for a char: chr() and ord() functions

Anil_Babu_Samineni — Thu, 04 Aug 2016 10:39:48 GMT

Thanks, But bit difficult for me. I've posted on community, No one can resond that.

Date (Square) Problem

Re: How to find a number for a char: chr() and ord() functions

Anonymous — Wed, 15 Mar 2017 15:06:49 GMT

Muchas gracias

Re: How to find a number for a char: chr() and ord() functions

Anonymous — Fri, 24 Mar 2017 17:17:03 GMT

Thanks! This is very helpful.

Re: How to find a number for a char: chr() and ord() functions

Anonymous — Fri, 24 Mar 2017 19:13:03 GMT

This is great - it helped me find a way to add a colored arrow to a text box based on a calculation.

Re: How to find a number for a char: chr() and ord() functions

Thu, 27 Jul 2017 00:12:42 GMT

Nice and simple. Very helpful.

Re: How to find a number for a char: chr() and ord() functions

anushree1 — Mon, 05 Feb 2018 06:35:56 GMT

Very Helpful

Re: How to find a number for a char: chr() and ord() functions

ysj — Mon, 12 Feb 2018 06:03:42 GMT

it's fantastic. Thanks!

Re: How to find a number for a char: chr() and ord() functions

Lucky1 — Sun, 19 Mar 2023 12:14:00 GMT

Hi tried same logic in vizlib table it is not working.i want output like SSS&

JJJ

But IAM getting SSS&JJJ