Replace string between characters using regx_replace

Question

I have one column , which contain values like - $test test12$ test14 I have to update the value the between $$. like-$test done$ test14

I have tried to solve this by using :-

select REGEXP_REPLACE('$test test12$ test14','$(.*?)$','test done') from dual

But not working

Given String -$test test12$ test14 Expected result - $test done$ test14

What should happen if it has $test test12$ test14$

Kaushik Nayak
– Kaushik Nayak

2019-06-17 05:03:31 +00:00
Commented Jun 17, 2019 at 5:03 — Kaushik Nayak
– Kaushik Nayak, Commented Jun 17, 2019 at 5:03

Tim Biegeleisen · Accepted Answer · 2019-06-17 05:01:44Z

3

The character $ is a rexeg metacharacter, which has a special meaning (it means the end of the input or current line). It you want to target literal $, then it needs to be escaped:

SELECT
    REGEXP_REPLACE('$test test12$ test14', '\$(.*?)\$','$test done$')
FROM dual;

The above outputs:

$test done$ test14

answered Jun 17, 2019 at 5:01

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Replace string between characters using regx_replace

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related