Decimal to String (TD to XML file)

[vinaymanchinila]

Hi,

Converting a decimal to string (reading from teradata source, writing to XML file),

TgtCol:String[10]=string_from_decimal[fix_zero](SrcCol)

SrcCol = 2.56


The result os ' 000002.56' is there a way to avoid the leading space and have a 0 instead?


Thanks,

[ArndW]

The string_from_decimal doesn't have an option to suppress the sign character so you will always get it and need to remove it. A modify stage can't use embedded functions, but you could put another modify stage with a trim() to get rid of the leading spaces or just a substring function to get rid of the first char or a replace function to replace the leading space with a "+" sign or "0".

[vinaymanchinila]

Hi ArndW, I used the replace function and I was wondering if we could have handled it in the StringfromDecimal function, thanks for the information.

[ray.wurlod]

It is my belief (originally suggested by an Ascential technical person) that two consecutive Modify stages are slightly less efficient than a single Transformer stage.

[ArndW]

Ray - I'll keep that in mind; I've never experimented with the PX transform speed, I think that the long copmile times led me to believe it would also execute slowly