Page 1 of 1

DecimalToString

Posted: Tue Oct 17, 2006 6:30 am
by bakul
I have an input column(BIGINT). I am using DecimalToString on this column and writing it to output (VARCHAR(20)).
However, the output field is populated with empty string. I have tried converting the input column to a decimal and then using the function but it still outputs an empty string.
The syntax I am using is DecimalToString(InputField).

We are aware that there is an issue with this function in version 7.1 and it does not give the expected result. But we are now using 7.5. Is anyone else facing this problem?

Posted: Tue Oct 17, 2006 6:36 am
by kumar_s
What is the value of the decimal in the source?
Try DecimalToString(InputField,'fix_zero').

Posted: Wed Oct 18, 2006 6:50 am
by bakul
The value of the input field is 5000. I have tried the function with "fix_zero". But it still does not work.

Posted: Wed Oct 18, 2006 7:27 am
by Krazykoolrohit
are there no warnings when you run the job? can you post the warnings