Postgresql replace all occurrences of string+

Question

I have this string:

this is the abcd xxx
string I want to abcd yyy
replace in my text abcd zzz

Now I want to replace abcd and anything after it with blank.

I want this result:

this is the
string I want to 
replace in my text

I tried:

select regexp_replace(str, 'abcd.*','','gi')

But it just removed everything after the first match. Also other combos without luck.

What am I missing?

Thanks!

klin · Accepted Answer · 2018-08-02 18:07:20Z

1

Use the flag n (newline-sensitive matching) in regexp_replace():

with my_table(str) as (
values(
'this is the abcd xxx
string I want to abcd yyy
replace in my text abcd zzz')
)

select regexp_replace(str, 'abcd.*','','gin')
from my_table

   regexp_replace    
-----------------
 this is the        +
 string I want to   +
 replace in my text 
(1 row)

edited Aug 2, 2018 at 18:07

answered Aug 2, 2018 at 17:52

klin

123k15 gold badges240 silver badges262 bronze badges

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

Collectives™ on Stack Overflow

Postgresql replace all occurrences of string+

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