RE: Replacing characters inside of a string

Thanks to all for the examples!

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jack Woehr via MIDRANGE-L
Sent: Monday, March 7, 2022 12:56 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: Jack Woehr <jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx>
Subject: Re: Replacing characters inside of a string

In iACS:

create variable jwoehr.FOO varchar(20); -- there is a schema JWOEHR on my IBM i set jwoehr.FOO = REGEXP_REPLACE ( 'meatballs', 'a.*l', 'ow'); -- replace starting at first 'a' any chars or spaces up to last 'l'
values jwoehr.foo; -- show me!

*shows below in the output:*

00001
meows

On Mon, Mar 7, 2022 at 10:21 AM Jack Prucha <Jack.Prucha@xxxxxxx> wrote:

I have a requirement to change some character fields in a file. Leave
the first and last character as is and replace all the between
characters with a fill character such as an asterisk.

For example:

'Jack' = 'J**K'
'iSeries = 'i*****s'

I'm testing SQL statements with hard-coded strings. I thought I had a
solution with TRANSLATE because it has a fill character parameter but
it wants to translate the 1st and last characters if they happen to
match one of the between characters. I don't know where to begin with perhaps
REGEXP_REPLACE. I'm back at square one now and don't see any
straightforward SQL methods to do this. I know this can be done with
RPG but hoping to do this without 'code'.

TIA
Jack



This email, including any documents, files, or previous email messages
attached to it, has been sent from an email account of College
Foundation Inc., (CFI) and may contain confidential, proprietary, or
legally privileged information belonging to CFI. If you are not the
intended recipient, any dissemination, distribution, or copying of
this email or its attachments is strictly prohibited. If you have
received this email in error, please immediately notify the sender by
email and destroy the original email and any attachments.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
Jack Woehr, IBM Champion 2021-2022
<https://www.youracclaim.com/badges/528d23d6-087f-4698-8d17-d59688106ac4/public_url>
Absolute Performance, Inc.
12303 Airport Way, Suite 100
Broomfield, CO 80021

NON-DISCLOSURE NOTICE: This communication including any and all attachments is for the intended recipient(s) only and may contain confidential and privileged information. If you are not the intended recipient of this communication, any disclosure, copying further distribution or use of this communication is prohibited. If you received this communication in error, please contact the sender and delete/destroy all copies of this communication immediately.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com