Formatting decimal value

monaz · Post by **monaz** » Wed May 06, 2009 12:06 am

Hi,

I need to format the decimal values coming from a source in this format
NNN.NNNNNNNN, i.e if the input is 6.56 the output should be
006.56000000,
I have tried using the fmt function but i'm not able to get the required output

Can someone help me with this

ray.wurlod · Post by **ray.wurlod** » Wed May 06, 2009 12:49 am

Code: Select all

Fmt(Field(InLink.TheNumber,".",1,1), "R%3") : "." : Fmt(Field(InLink.TheNumber, ".", 2, 1), "L%8")

Kryt0n · Post by **Kryt0n** » Wed May 06, 2009 1:08 am

Isn't there a setting to pad decimals with zeros? Or is it just a parallel job setting?

verify · Post by **verify** » Wed May 06, 2009 2:18 am

As per the query the target decimal output is [11,8].
If we set this at the target, by default datastage will append zeroes to it.
No need of expicitly handling that.

If i'm wrong please correct me Ray..

ray.wurlod · Post by **ray.wurlod** » Wed May 06, 2009 4:37 pm

In server jobs you're wrong. DataStage server jobs always return the smallest possible string from any arithmetic operation - this means trimming leading and trailing non-significant zeroes, whether you want that or not.

rgr · Post by **rgr** » Mon May 11, 2009 2:01 pm

Hi Monaz,
I am not sure but try this ('0000000000':Iconv(InLink.TheNumber, "MD2"))[10]

thanks,
rgr