Hi
I have to match some text pattern in a data. Is it possible to use regular expression in Data Stage parallel job?
Can we use regular expression in DataStage job??
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3
- Joined: Mon Oct 13, 2008 1:49 am
No in the job, but you can always shell out to the OS and use regular expressions and functions there.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 301
- Joined: Thu Jul 14, 2005 10:27 am
- Location: Melbourne, Australia
- Contact:
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.
(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.
<b>John McKeever</b>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.