Can we use regular expression in DataStage job??

sandeep8.s · Post by **sandeep8.s** » Wed Nov 05, 2008 1:07 am

Hi
I have to match some text pattern in a data. Is it possible to use regular expression in Data Stage parallel job?

ArndW · Post by **ArndW** » Wed Nov 05, 2008 2:59 am

No in the job, but you can always shell out to the OS and use regular expressions and functions there.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 05, 2008 7:11 am

Filter stage has limited regexp capability.

jhmckeever · Post by **jhmckeever** » Wed Nov 05, 2008 8:24 pm

You could add your own regular expression support using the C-source I posted <b><a href="viewtopic.php?t=107882">Here</a></b>.

(Although I'm beginning to wonder why I bothered, as nobody seems to like using <b><a href="search.php">Search </a></b> much these days)

J.

Nagaraj · Post by **Nagaraj** » Tue Nov 18, 2008 6:51 pm

Ray can you please give an example here? thanks

ray.wurlod · Post by **ray.wurlod** » Tue Nov 18, 2008 8:30 pm

The WHERE clause can use the LIKE operator followed by a regular expression. This is documented early in the chapter on the Filter stage in the Parallel Job Developers Guide manual.