Decimal field validation

sethuraman · Post by **sethuraman** » Tue May 08, 2012 3:54 am

Hi,
I have a input file and i read the value " 2222.22" as Char(12) and I convert it to Decimal(11,2).
By the way, I should validate it as if it has only numbers and no other characters is there like " 33AB.33". If at all any characters found then i should reject the record. how to handle this validation? Please help.

Thanks,
Sethuraman.

tsamui · Post by **tsamui** » Tue May 08, 2012 4:27 am

Have you tried with Num function in transformer?

chulett · Post by **chulett** » Tue May 08, 2012 6:17 am

Why not use the IsValid() function?

DSXchange

Decimal field validation

Decimal field validation

Re: Decimal field validation