Checking for Valid Phone Numbers

DSkkk · Post by **DSkkk** » Wed Apr 13, 2005 12:17 pm

Hi all!!

I have a situation where i have to check the Phone Number field, whether its all Numeric. I have dealt this scenario previouly by writing a Routine. But that was a Server job. Now i need to do this in parallel job. Could anyone suggest if if there is any such function in Parallel jobs or How can i write the Routine in a parallel job...

Thanks in advance!!

mouthou · Post by **mouthou** » Wed Apr 13, 2005 2:11 pm

Hi Kiran,

There is a function in PX called Num(input field). This returns 1 if the input varchar field is convertible to number. With this returned value you can find that it contains only numeric...

Best of luck!

jasper · Post by **jasper** » Thu Apr 14, 2005 5:23 am

You can always use a basic-transformer in a parallel job, then you can just use your old routine.
watch out: on the one hand DS discourages the use of the Basic transformer in PX-jobs, on the other hand they give this same solution when you're experiencing problems in C-routines and development.
(I've got a post in this forum about c-routines and from the major-response to this, I think everyone is still using basic.)

legendkiller · Post by **legendkiller** » Thu Apr 14, 2005 5:41 am

I guess you can also use IsValid function which can be called from parallel transformer