Convert Decimal to Hex

[natanzi]

Dears,
I need to convert decimal value to Hex format, is there any idea for this item?

BR,
Milad

[mlauber71]

One possibility is to use r package broman to convert them.

use R to convert hex to dec – mlauber71

[armingrudd]

Hi @natanzi,

You can also use the Column Expressions node:

decimal = column("column1")
hex=""
hexchars = arrayCreate('0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F')
while(decimal>0)  {  
       rem=decimal%16 
       hex=join(hexchars[rem],hex)  
       decimal=floor(decimal/16)
}
hex 

Where “column1” is the name of the column which contains decimal values.

[natanzi]

Dears @mlauber71 @armingrudd
Thanks miliion!

BR,
Milad