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