Remove all salacious words

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Gius
Participant
Posts: 29
Joined: Mon Mar 09, 2015 2:10 am

Remove all salacious words

Post by Gius »

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
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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

"You can never have too many knives" -- Logan Nine Fingers
rkashyap
Premium Member
Premium Member
Posts: 532
Joined: Fri Dec 02, 2011 12:02 pm
Location: Richmond VA

Post by rkashyap »

This post may interest you.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

ASS is not necessarily salacious, for example when it refers to a quadruped beast of burden.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply