nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Hex to Binary

data_nerd

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:

Accepted answers

txnelson

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);

All comments

jthi

This might give some ideas hextonumber not working with 64bits

Mark_Zwald

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

data_nerd

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.

txnelson

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);