DSXchange

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

Use Index() to perform a substring match.