topic Re: Hex to Binary in Discussions

Hex to Binary

data_nerd — Tue, 05 Nov 2024 18:40:50 GMT

I have a HEX number that I want to convert to binary. I can do this manually for one hex at a time from this website (Hex to Binary Converter), but I can't figure out how to do this in jmp.

Example from the web:

My attempt in JMP:

HEX2BIN formula:

Any guidance would be much appreciated. Thanks!

Links that haven't helped so far:

Re: Hex to Binary

jthi — Tue, 05 Nov 2024 18:35:12 GMT

Re: Hex to Binary

Mark_Zwald — Tue, 05 Nov 2024 18:42:48 GMT

This thread discusses HextoNumber: https://community.jmp.com/t5/Discussions/hextonumber-not-working-with-64bits/m-p/801201

Re: Hex to Binary

data_nerd — Tue, 05 Nov 2024 18:59:00 GMT

The thread mentioned says

To break my HEX string in half and then proceed with the conversion to binary. I've tried that in rows 2 and 3 below without success. I don't mind break it up into individual characters, but still can't figure out how to get 0s and 1s.
To specify the base(16) inside of the Hex To BLOB, but no additional inputs seem to be allowed in Hex To BLOB
To switch to python in JMP 18, but I unfortunately only have access to JMP 17.2.0

Any other ideas? I'm trying to get a series of 1s and 0s.

Re: Hex to Binary

txnelson — Tue, 05 Nov 2024 19:05:54 GMT

Here is my brut force way of handling this

Names Default To Here( 1 );

theArray = ["0" => "0000",
"1" => "0001",
"2" => "0010",
"3" => "0011",
"4" => "0100",
"5" => "0101",
"6" => "0110",
"7" => "0111",
"8" => "1000",
"9" => "1001",
"A" => "1010",
"B" => "1011",
"C" => "1100",
"D" => "1101",
"E" => "1110",
"F" => "1111"];

theHex = "F061F997862C3E70";
theBinary="";
for(i=1,i<=length(theHex),i++,
	theBinary = theBinary || (theArray << getvalue(substr(theHex,i,1)))
);

Show(theBinary);