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.
Decimal field validation
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 8
- Joined: Tue Jan 12, 2010 10:34 pm
- Location: Chennai
Re: Decimal field validation
Have you tried with Num function in transformer?
Thanks&Regards
-------------------
Tsamui
-------------------
Tsamui