pattern matching

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
pavan_test
Premium Member
Premium Member
Posts: 263
Joined: Fri Sep 23, 2005 6:49 am

pattern matching

Post by pavan_test »

Can someone please let me know how can I perform pattern matching in datastage.

I have a string such as "capital city is AUSTIN"

I have to find if the incoming string has "AUSTIN" (always in caps) and if it find a match then write "AUSTIN" to output.

Thanks & Regards
Pavan
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Use Index() to perform a substring match.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
Post Reply

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