I have fields that contain long Hexidecimal numbers
The prefix is the 0's and the four F's. So the only needed characters are the last 8 (2 for each octet of the IP address).
This number needs to be converted to an IP address but when I convert from Hex to Decimal, it doesn't recognize that there are 4 separate numbers in there, so I get a value of 2,###,###,### for each field.
How can I get around this without doing all kinds of splitting and re-merging functions?
I fear there's no easy way around it, but thought I would ask first.