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
cherry
Participant
Posts: 108 Joined: Sun Jul 10, 2005 1:35 am
Post
by cherry » Tue Dec 09, 2008 4:25 pm
Hi All,
I have a value coming from source as 'XXX YYY ZZZ', I need to extract as 'YYY ZZZ' into target.Is there any function in DS to achieve this. If yes Please let me know.
Thanks In Advance
Best Regards
Cherry
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Tue Dec 09, 2008 4:30 pm
If the requirement is "two adjacent fields from a space delimited string starting from the second field" then Field() will do the trick:
-craig
"You can never have too many knives" -- Logan Nine Fingers
cherry
Participant
Posts: 108 Joined: Sun Jul 10, 2005 1:35 am
Post
by cherry » Tue Dec 09, 2008 5:03 pm
I even get the data like 'XXX YYY ZZZ AAA'
Best Regards
Cherry
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Tue Dec 09, 2008 5:06 pm
That's fine, what I posted will still work. Did you try it?
-craig
"You can never have too many knives" -- Logan Nine Fingers
cherry
Participant
Posts: 108 Joined: Sun Jul 10, 2005 1:35 am
Post
by cherry » Tue Dec 09, 2008 6:17 pm
Hi Chullet,
Its working fine, Thank a lot
Regards
Cherry
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Dec 10, 2008 8:35 am
In that case, you need to mark the subject as Resolved using the button at the top of the screen.
-craig
"You can never have too many knives" -- Logan Nine Fingers