DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
ecclesr



Group memberships:
Premium Members

Joined: 05 Apr 2003
Posts: 260
Location: Australia
Points: 2517

Post Posted: Sat Jul 11, 2020 5:46 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
First time creating pattern subroutine expressions

My data has words like

MENS HOUSE
MEN'S HOUSE

I would like to create an expression in the Apostrophes SUBROUTINE that would handle words ending with 'S and replace with just S e.g. MENS

Thanking you all in advance
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54582
Location: Sydney, Australia
Points: 295988

Post Posted: Sat Aug 01, 2020 4:12 pm Reply with quote    Back to top    

I'm unable to check at the moment, but isn't there an apostrophes subroutine in the xxNAME rule sets that you could adapt? Otherwise, use a conditional pattern to identify a token that ends in "' ...

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours