convert Exponential value to numeric value in mapping

[Former Member]

Hi Friends

I want to convert the value

3.37E+12 to 3370000000000,

how can i do this in mapping.

Thanks

Srinivas

[Former Member]

Thanks for your help

[Former Member]

Srinvias,

Create a user defined function with name Convert and take one argument 'a'.

Import: java.math.;*

Add this code:

BigDecimal bigA = new BigDecimal(a);

return bigA.toString();

Then source --> convert udf --> target. You should get what you are expecting.

Regards,

---Satish