New to Qlikview, but we have been trying to work through a conversion and have not found the correct method to tackle this yet.
We have a multi digit hexidecimal number that we are trying to convert into it's decimal equivalent. We are pulling this from a mainframe file that is in EBCDIC format. The value is 563B which should convert into 22075. We've tried defining it as I, B and U with little to no success. By using NUM we have managed to get the first byte to convert from 56 to 86, and the second 3B to convert to 59. When we try and pull the full two bytes in, it looks like it is instead taking the 3B as the high order byte and the 56 as the low order byte. It's reading it byte by byte from right to left instead of left to right. So here we are a Big Endian architecture versus what it looks like Qlikview is doing which is Little Endian.
Is the only way to do this is to convert this to a string and pull it apart character by character and multiplying?
Thanks in advance for any help on this.
Mark
