Creating a Hex to Dec formula

Hey guys,

Attached is a file that I use for a formula in excel to convert hexs to decs (Cell C3) and vice versa (Cell C6). Is there a formula that can do what this function is doing in excel? I don't think Alteryx has a Hex2Dec formula or a concatenate formula.

Any help would be appreciated. Thanks!

Copy of MEID hex dec.xlsx

Developer Tools

Best Practices

Preparation

Expression

Accepted answers

patrick_digan

@vtika16 I think the formulas would look something like this. Alteryx just uses a + instead of Concatenate. Alteryx has hextonumber and inttohex functions that you can use. I'm attaching a simple workflow that implements both calculations.

Hex to Dec:

Right("00000000"+tostring(HexToNumber(Left([Hex],8))),10) +Right("000000000000"+tostring(HexToNumber(Right([Hex],6))),8)

Dec to Hex:

Right("000000"+inttohex(tonumber(Left([Dec],10))),8)+Right("000000"+inttohex(tonumber(Right([Dec],8))),6)

Hex and Dec.yxmd

All comments

patrick_digan

Hex to Dec:

Right("00000000"+tostring(HexToNumber(Left([Hex],8))),10) +Right("000000000000"+tostring(HexToNumber(Right([Hex],6))),8)

Dec to Hex:

Right("000000"+inttohex(tonumber(Left([Dec],10))),8)+Right("000000"+inttohex(tonumber(Right([Dec],8))),6)

Hex and Dec.yxmd

vtika16

Patrick,

Thank you. I just found the hex2number function. I didn't know it would be that easy for a transition from the excel formula to Alteryx. Much appreciated.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335