Decimal format

[sudarshan]

Hi,

In a transformer I am converting decimal coming in as varchar to decimal. When I use no conversion function it automatically converts correctly. For inputs which are not in decimal format it gives default zero.

But when I use

Code: Select all

If  IsValid("decimal",Trim(DSLink2.DECIMAL_1))=1 Then Trim(DSLink2.DECIMAL_1) Else "99.99"

it sets all values as 99.99, even the correct ones.

[kumar_s]

Hi,
Not much sure, but with some previous posts.....

try "decimal[n,m]"


regards
kumar