DecimalToString

bakul · Post by **bakul** » Tue Oct 17, 2006 6:30 am

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?

kumar_s · Post by **kumar_s** » Tue Oct 17, 2006 6:36 am

What is the value of the decimal in the source?
Try DecimalToString(InputField,'fix_zero').

bakul · Post by **bakul** » Wed Oct 18, 2006 6:50 am

The value of the input field is 5000. I have tried the function with "fix_zero". But it still does not work.

Krazykoolrohit · Post by **Krazykoolrohit** » Wed Oct 18, 2006 7:27 am

are there no warnings when you run the job? can you post the warnings