How to convert hexadecimal value to decimal in data stage

[radhika7983]

Hi, I have a requirement where I need to convert hexadecimal value coming from source to Decimal in the target.
Suppose if the source value is X'0055', than the target should be 85. Can some one suggest? Should we do it by calculations, like dividing by 16 and than considering the remainder and quotient? Or is there any other way?

Thank You

[chulett]

So... what is your literal source value? In your example, would it be 55 or literally the X'0055' string you've shown?

[elias.shaik]

if the source is a table then you can use sql funtions to convert hexadecimal to decimal in a better way.

[mnayer]

Hi, I have a requirement where I need to convert hexadecimal value coming from source to Decimal in the target.
Suppose if the source value is X'0055', than the target should be 85. Can some one suggest? Should we do it by calculations, like dividing by 16 and than considering the remainder and quotient? Or is there any other way?

Thank You

Actually you can create a simple c function and a routine to be used in a transformation stage.

M. Nayer