Print Page - Convert from Hexadecimal value to Ascii ?

Title: Convert from Hexadecimal value to Ascii ?
Post by: PRIT AMRIT on 17 Mar 2011 02:13:36 AM

Hi guru's,

Is it feasible to convert from Hexadecimal value to Ascii?

E.g.636174 =cat

http://www.string-functions.com/hex-string.aspx (http://www.string-functions.com/hex-string.aspx)

Thanks
Prit

Title: Re: Convert from Hexadecimal value to Ascii ?
Post by: Rutulian on 17 Mar 2011 11:15:34 AM

Hi Prit,

You could get the ASCII list from somewhere like http://www.ascii.cl/ (http://www.ascii.cl/) and use it as a lookup table. Seems like something that might better be done by type conversion at an earlier stage though - if you have hex values that you know are ascii characters, why not just deal with them as a kind of varchar?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: PRIT AMRIT on 17 Mar 2011 02:13:36 AM