phone number

pavan_test · Post by **pavan_test** » Fri May 21, 2010 11:55 am

Hi All,

I have incoming data as (800) 123-4561 and expected output is 8001234561
Can anyone please suggest me how do i accomplish this.

Thank
Mark

anbu · Post by **anbu** » Fri May 21, 2010 12:10 pm

Use convert function to remove unwanted characters

Convert("() -","",Phone_No)

Harini · Post by **Harini** » Tue May 25, 2010 12:15 am

anbu wrote:Use convert function to remove unwanted characters
Code: Select all
Convert("() -","",Phone_No)

Is the syntax same, to use in both modify and transformer stage?

ETLJOB · Post by **ETLJOB** » Tue May 25, 2010 12:36 am

No. Modify stage has it's very own syntax for every operation that it can perform. Bit complex too unless you are a master of those

ray.wurlod · Post by **ray.wurlod** » Tue May 25, 2010 2:32 am

This particular operation is not possible in the Modify stage.

Harini · Post by **Harini** » Thu May 27, 2010 4:19 am

ray.wurlod wrote:This particular operation is not possible in the Modify stage. ...

Oh, thank you.. !

mkkgupta · Post by **mkkgupta** » Thu May 27, 2010 10:15 am

Hi,

Thank you Guys!

Its not necessary in my job however I can resolve if requirement comes.

Author,
please update is as resolved!

DSXchange