topic Is there a function to convert a character to its ASCII equivalent? in Discussions

Is there a function to convert a character to its ASCII equivalent?

LikelihoodFaces — Fri, 09 Jun 2023 16:57:56 GMT

Is there a function to conver a character to an ascii number?

In the end I need to translate a character based column in data into its numerical equivalent. They always happen to be 1 or 2 digits. So effectively

"A" becomes 1

"Z" becomes 26

"AA" becomes 27

"AB" becomes 28

etc.

So say DIE_COLUMN = "CA" I want to return 79

I've come up with the following thoroughly ugly formula... but if there was a char to ascii function I could do a lot better. There HAS to be a cleaner way.

If( Length( :DIE_COLUMN ) == 2,
	Contains( "ABCDEFGHIJKLMNOPQRSTUVWXYZ", Left( :DIE_COLUMN, 1 ) ) * 26,
	0
) + Contains( "ABCDEFGHIJKLMNOPQRSTUVWXYZ", Right( :DIE_COLUMN, 1 ) )

Re: Is there a function to convert a character to its ASCII equivalent?

txnelson — Thu, 28 Apr 2022 16:21:55 GMT

For the translation you are doing, your function works. If an ASCII to Decimal function was used, the character "A" would return 65

Re: Is there a function to convert a character to its ASCII equivalent?

Craige_Hales — Thu, 28 Apr 2022 16:45:47 GMT

Translating 2 character codes to a number is a good job for an associative array. You could create the aa with nested for loops. You might want to force lower case on the keys .

Re: Is there a function to convert a character to its ASCII equivalent?

pmroz — Thu, 28 Apr 2022 18:36:47 GMT

This will do it:

die_column = "CA";
If( Length( DIE_COLUMN ) == 2,
	(num(hex(Left( DIE_COLUMN, 1 ) )) - 40) * 26,
	0
) + num(hex(Right( DIE_COLUMN, 1 ) )) - 40

You would need to uppercase die_column. This works because A is ASCII 41.