Oracle regular expression replace in string ignoring first and last characters

Question

regular expression replace in string ignoring first and last characters if they matched

my try

SELECT REGEXP_REPLACE ('TLYU TK0T23T', '[^(\A.)]T[^(.\Z)]', 'Qq' ) contain FROM dual;

result

TLYUQqQq3T

expected result

TLYU QqK0Qq23T

Thanks in advance

Bobby Durrett · Accepted Answer · 2018-07-18 15:05:11Z

1

This returns the answer you want:

SELECT REGEXP_REPLACE 
('TLYU TK0T23T', '([^(\A.)])T([^(.\Z)])', '\1Qq\2' ) contain 
FROM dual;

Bobby

answered Jul 18, 2018 at 15:05

Bobby Durrett

2313 silver badges10 bronze badges

1 Answer 1