Re: Replacing characters inside of a string

[Jack Woehr <jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx>]

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