Number format

[Variation180]

This is prabably a dumb question and I'm prabably overlooking the obvious, but....

I need to format a number to a string format of "0000000.00". I have to have 7 characters to the left of the decimal and 2 to the right. I would do this in oracle with to_char(mynumbervalue,'0000000.00'), however the to_char() function in informatica apparently does not accept formatting on numbers. Does anyone know of a way to do this?

Thanks,
Chris

Charlotte, NC

 

[blom0344]

The TO_CHAR works with numeric values as well:

TO_CHAR(100.61) is '100.61'

Use the LPAD function to pad to a fixed length...

T. Blom
Information analyst
tbl@shimano-eu.com