NUMBER TO VARCHAR

bobby · Post by **bobby** » Mon Aug 09, 2004 1:08 pm

hi,
i have ORDER ID 1001
AND OMC ID MCS1001
I WANT TO COMPARE 1001 TO BE COMPARE WITH MCS1001 SO THAT
MCS SHOULD BE TRUNCATED AND I GET ONLY 1001 in transformer
PL. INFORM
Thanks,
Bobby

neena · Post by **neena** » Mon Aug 09, 2004 2:42 pm

CHECK DIGITS Routine

Thanks

rasi · Post by **rasi** » Mon Aug 09, 2004 6:21 pm

Use Iconv(Arg1,"MCN"). This will extract only the numbers from the Arg1.

Thanks
Siva

ray.wurlod · Post by **ray.wurlod** » Mon Aug 09, 2004 9:43 pm

Guess what the defining expression for the DIGITS Transform is?

Don't you thing that DIGITS is a more easily remembered name than Oconv(Arg1, "MCN") ?