DSXchange

Posted: **Sat Nov 20, 2010 6:30 am**

ray.wurlod wrote:Did you mean DecimalToString() ?

Yes, made a typo.

Sorry about that
SV1 : DecimalToString(column_name) --> DataType = VarChar
SV2 : Field(SV1,'.',1) --> DataType = Integer
SV3 : Right(SV1,2) --> DataType = VarChar

Derivation : SV2:'.':SV3 --> DataType = VarChar

Posted: **Thu Dec 02, 2010 2:43 am**

you can use fix function

Posted: **Mon Dec 06, 2010 12:11 am**

Hi,

You can use DecimalToString(<Column_Name>,"suppress_zero").

Naveen

DSXchange

Convert value from -00005.55 to -5.55