Hexadecimal number conversion

longhui

Hello everyone, request to solve a problem：

There is a string of hexadecimal digits:02C89A2B1400000000D2CCE91600000000，divided into three parts

1.02

2.C89A2B1400000000 → C8 9A 2B 14 00 00 00 00（A group of two）→ 00 00 00 00 14 2B 9A C8（Reverse order）

3.D2CCE91600000000 → D2 CC E9 16 00 00 00 00 （A group of two）→ 00 00 00 00 16 E9 CC D2 （Reverse order）

00000000142B9AC8 and 00000000142B9AC8 Convert to decimal

Python can handle, but want to use Alteryx to solve，thanks!

Preparation

Accepted answers

RobertOdera

Hi @longhui

Please mark as a Solution if this works for you.

Please try the below in Formula Tools (assuming the pattern I discern in your data).

Let Input = 02C89A2B1400000000D2CCE91600000000

Then:

First = Left(Trim(Input),2)

Input_2 = TrimLeft(Input,[First])

Get substrings.

Sub1 =Substring([Input2],0,2)

Sub2 =Substring([Input2],2,2)

Sub3 =Substring([Input2],4,2)

Sub4 =Substring([Input2],6,2)

Sub9 =Substring([Input2],16,2)

Sub10 =Substring([Input2],18,2)

Sub11 =Substring([Input2],20,2)

Sub12 =Substring([Input2],22,2)

Therefore:

Second = PadLeft([Sub4]+[Sub3]+[Sub2]+[Sub1], 16, '0')

Third = PadLeft([Sub12]+[Sub11]+[Sub10]+[Sub9], 16, '0')

Finally:

Hex To Number of Second = HexToNumber(Second)

Hex To Number of Third = HexToNumber([Third])

Please see attachment.

Good Luck!

For_longhui.yxmd

All comments

ponraj

Use formula tool with function HexToNumber(x) to convert hexadecimal to number.