Re: LPEX RegEx Replace

[Craig Richards <craig@xxxxxxxxxxxxxxxx>]

The replacement string is an expression, which can refer to capture groups
from the regular expression pattern.

Here is a simple example without using capture groups:

Just showing the data:

with t1 as (select 'Craig is 55 today' text from sysibm/sysdummy1)
select * from t1

Craig is 55 today

Then with regexp replace:

with t1 as (select 'Craig is 55 today' text from sysibm/sysdummy1)
select regexp_replace(t1.text, '\d{2}', 'Really Old') from t1

Craig is Really Old today

Will look for exactly 2 digits in the source string and replace with the
text "Really Old"

If you to be fancier, you can specify capture groups in the pattern
expression and refer to them in the Replace Expression via \1, \2 etc.




On Fri, 28 Jun 2019 at 15:08, Justin Taylor <JUSTIN@xxxxxxxxxxxxx> wrote:

> I'm trying to use a regular expression to do a Replace within SQLRPGLE
> code.  The "Regular expression" works for Find, but not Replace.  Rather
> than apply the Replace regular expression, it uses it as literal text and I
> end up with the regular expression in my source code.
>
> Is that just the way it works?
>
> TIA
> --
> This is the Rational Developer for IBM i / Websphere Development Studio
> Client for System i & iSeries  (WDSCI-L) mailing list
> To post a message email: WDSCI-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/wdsci-l
> or email: WDSCI-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/wdsci-l.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com