Convert HEX value to IP address

[realpixel]

Hello,

On my chart, I have a column "SourceIP" with Hexadecimal value, like "0A5C0158", if I convert manualy this value to decimal I obtain 10.92.1.88 now I want to know if there are a possibility to convert all value in my chart from HEX to IP address, someone have an idea?

[MarcoWedel]

Hi,

another solution could be:

tabIP:
LOAD *,
    Dual(Mod(HexNum>>24,256)&'.'&Mod(HexNum>>16,256)&'.'&Mod(HexNum>>8,256)&'.'&Mod(HexNum,256),HexNum) as IP;
LOAD *,
    Num#(HexTxt,'(HEX)') as HexNum
Inline [
HexTxt
0A5C0158
3F2CA86E
7F000001
];

hope this helps

regards

Marco