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



Joined: 09 Mar 2015
Posts: 19

Points: 286

Post Posted: Fri Mar 04, 2016 2:52 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Server
OS: Windows
Hello, I have the same problem as noted here but still don't see the solution.

I have to replace in an input string ( for example ADDRESS ) all the salacious words with Empty string for example ADDRESS = "Street Ass" then my output should be ADDRESS = "Street"

If I use the ereplace function , I have to put all in uppercase to match "ASS" BUT I need to keep my original case.

Is there any function that is case insensitive?

Thank you -
chulett

Premium Poster


since January 2006

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

Joined: 12 Nov 2002
Posts: 42274
Location: Denver, CO
Points: 217071

Post Posted: Fri Mar 04, 2016 7:47 am Reply with quote    Back to top    

Eight years later and not the same, similar perhaps but not the same. Let's get you in your own post and make sure I have your particulars correct... version 11x on Windows, Server job, yes?

How are you going to determine which of the words in your string are 'salacious' and thus need to be removed? Do you have a list that is driving this?

_________________
-craig

Watch out where the huskies go and don't you eat that yellow snow
Rate this response:  
Not yet rated
rkashyap



Group memberships:
Premium Members

Joined: 02 Dec 2011
Posts: 498
Location: Richmond VA
Points: 4518

Post Posted: Fri Mar 04, 2016 9:44 am Reply with quote    Back to top    

This post may interest you.
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 54071
Location: Sydney, Australia
Points: 293279

Post Posted: Fri Mar 04, 2016 3:12 pm Reply with quote    Back to top    

ASS is not necessarily salacious, for example when it refers to a quadruped beast of burden.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
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