Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett, rschirm, roy
-
pavan_test
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
Post
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
-
anbu
- Premium Member
- Posts: 596
- Joined: Sat Feb 18, 2006 2:25 am
- Location: india
Post
by anbu »
Use convert function to remove unwanted characters
You are the creator of your destiny - Swami Vivekananda
-
Harini
- Premium Member
- Posts: 80
- Joined: Tue Mar 16, 2010 1:32 am
Post
by Harini »
anbu wrote:Use convert function to remove unwanted characters
Is the syntax same, to use in both modify and transformer stage?
-
ETLJOB
- Participant
- Posts: 87
- Joined: Thu May 01, 2008 1:15 pm
- Location: INDIA
Post
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
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
by ray.wurlod »
This particular operation is not possible in the Modify stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
Harini
- Premium Member
- Posts: 80
- Joined: Tue Mar 16, 2010 1:32 am
Post
by Harini »
ray.wurlod wrote:This particular operation is not possible in the Modify stage. ...
Oh, thank you.. !
-
mkkgupta
- Premium Member
- Posts: 17
- Joined: Thu Jan 24, 2008 10:13 pm
Post
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!
Regards
Kiran