Page 1 of 1
phone number
Posted: Fri May 21, 2010 11:55 am
by pavan_test
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
Posted: Fri May 21, 2010 12:10 pm
by anbu
Use convert function to remove unwanted characters
Posted: Tue May 25, 2010 12:15 am
by Harini
anbu wrote:Use convert function to remove unwanted characters
Is the syntax same, to use in both modify and transformer stage?
Posted: Tue May 25, 2010 12:36 am
by ETLJOB
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
Posted: Tue May 25, 2010 2:32 am
by ray.wurlod
This particular operation is not possible in the Modify stage.
Posted: Thu May 27, 2010 4:19 am
by Harini
ray.wurlod wrote:This particular operation is not possible in the Modify stage. ...
Oh, thank you.. !
Thanks
Posted: Thu May 27, 2010 10:15 am
by mkkgupta
Hi,
Thank you Guys!
Its not necessary in my job however I can resolve if requirement comes.
Author,
please update is as resolved!