Re: LPEX RegEx Replace

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