Data conversion

parameswar · Post by **parameswar** » Wed Sep 12, 2007 5:15 am

Hi,

I have source data in float type and values are coming in the format 1.01177e+12. I need to convert to decemal type with proper value.

Please suggest what to do. Is there any inbuild function/ routines to convert it? I tried dfloattodecimal(), but it is not working.

Thanks,
Parameswar

ray.wurlod · Post by **ray.wurlod** » Wed Sep 12, 2007 6:18 am

This IS a proper value. Due to the size of the number the data browser has been programmed to display it in "scientific notation".
1.01177e+12 means 1.01177 * 10**12, or (approximately) 1011770000000

Mhasan · Post by **Mhasan** » Thu Sep 13, 2007 9:53 pm

ray.wurlod wrote:This IS a proper value. Due to the size of the number the data browser has been programmed to display it in "scientific notation".
1.01177e+12 means 1.01177 * 10**12, or (approximately) 1011770000000

Thanks Mr. Ray. Above is my input in Float and output datatype is decimal.. Above calculation u done same i need to do in transformer ?
i did the below logic
DFloatToDecimal(inputcolumn.SEQUENCE[0,5] * pwr(10,12))
it is not working

If i do this
DFloatToDecimal(inputcolumn.SEQUENCE[0,5]) I get 0000000000000. as output what is the correct solution please suggest

Mhasan · Post by **Mhasan** » Thu Sep 13, 2007 9:53 pm

ray.wurlod wrote:This IS a proper value. Due to the size of the number the data browser has been programmed to display it in "scientific notation".
1.01177e+12 means 1.01177 * 10**12, or (approximately) 1011770000000

Thanks Mr. Ray. Above is my input in Float and output datatype is decimal.. Above calculation u done same i need to do in transformer ?
i did the below logic
DFloatToDecimal(inputcolumn.SEQUENCE[0,5] * pwr(10,12))
it is not working

If i do this
DFloatToDecimal(inputcolumn.SEQUENCE[0,5]) I get 0000000000000. as output what is the correct solution please suggest

ray.wurlod · Post by **ray.wurlod** » Thu Sep 13, 2007 10:43 pm

Just do nothing. Let the float number travel through your job. The scientific notation display is merely an artifact of the data browser. If you need to convert this to decimal, make sure that the decimal data type has a precision of at least 18 (six digits in your number and twelve in the exponent) and a scale of however may you need, for example 5. So, for example, try decimal[20,5] as the target data type.

Mhasan · Post by **Mhasan** » Thu Sep 13, 2007 11:00 pm

Thanks

Ray you didnt complee the sentence ,
you need to convert this to decimal, make sure that the ...
what need to be make SURE.... please let me know the exact solutions...

kwwilliams · Post by **kwwilliams** » Thu Sep 13, 2007 11:06 pm

He finished his sentence, you just need to make a small donation in order to view it!