Extract Data

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

Post Reply
cherry
Participant
Posts: 108
Joined: Sun Jul 10, 2005 1:35 am

Extract Data

Post by cherry »

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
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

If the requirement is "two adjacent fields from a space delimited string starting from the second field" then Field() will do the trick:

Code: Select all

Field(Link.Field, " ", 2, 2)
-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 »

I even get the data like 'XXX YYY ZZZ AAA'

Best Regards
Cherry
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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 »

Hi Chullet,

Its working fine, Thank a lot


Regards
Cherry
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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
Post Reply