parsing requirement

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

Post by chulett »

First use Field() with '~' as the delimiter to get your three pieces and then Field() again on each piece with ':' as delimiter and take the second field from each.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
suryapkakani
Participant
Posts: 47
Joined: Wed Aug 20, 2008 7:31 am
Location: New jersey

Post by suryapkakani »

Hi,

Thanks chulett, the logic worked good. Thanks again...

Regards,
sunny
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”