Negative Values in Decimal

[paranoid]

Hi,

We are having an input file where the negative decimal value is of the following format:

Eg: 123.00 -

We need to convert this to -123.00

Is there any simple function that we can achieve this?

Thanks

Sue :D

[ramsubbiah]

i am not sure if any separate function for achiving your result but try the below
use the substring function
column[(len(column)-1),1]:column[1,(len(column)-1)]

Thanks,
Ram.s

[rameshrr3]

You can use a transform or routine , Arg1 will be the input decimal column.. Assuming Server Jobs : )

Code: Select all

Ans = If Oconv(Arg1,"MC/N") Matches "...-..." 
Then Fmt(-1*Trim(Arg1,"-","A"),"R2") Else Arg1

[arunkumarmm]

Or you can even use a simple derivation like

If Count(Column,'-') > 0 Then '-' : Field(Column,'-',1) Else Column

[arunkumarmm]

Or you can even use a simple derivation like

If Count(Column,'-') > 0 Then '-' : Field(Column,'-',1) Else Column

[ray.wurlod]

Read about the Iconv/Oconv "MD" (masked decimal) conversions, which can handle trailing signs.

[Sreenivasulu]

Very good suggestion ray. This would be very useful

[ray.wurlod]

Something like

Code: Select all

 Iconv(InLink.TheDecimal, "MD2-") 

should do it.

[paranoid]

Thanks everyone.. I tried all the logics and finally used Ray's logic.

Have a nice day!!

Sue :D

[arunkumarmm]

Something like

Code: Select all

 Iconv(InLink.TheDecimal, "MD2-") 

should do it. ...

This is great. I never thought it would handle a trailing sign, though I use "MD" a lot. Thanks Ray.