Replace string in postgresql

Question

How to replace a string followed by any number with NULL .

Example [tag:1234:test][tag:5678:sql]

Here i need to replace tag:1234: with null

Result should be : [test][sql]

** tag string will be constant ,Numbers will vary .

Kindly help me on this.

Have you tried anything?

rghome
– rghome

2016-02-24 10:02:01 +00:00
Commented Feb 24, 2016 at 10:02 — rghome
– rghome, Commented Feb 24, 2016 at 10:02

pumbo · Accepted Answer · 2016-02-24 09:43:22Z

1

Here you go:

SELECT regexp_replace('[tag:1234:test][tag:5678:sql]', '\\[tag:\\d+:([^\\]]+?)\\]', '[\\1]', 'g')

It's done by using regexp_replace function with suitable regular expression and g (global) flag for replacing all matches.

edited Feb 24, 2016 at 9:43

answered Feb 24, 2016 at 9:37

pumbo

3,9162 gold badges29 silver badges29 bronze badges

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

2 Comments

user3007361 Over a year ago

Thanks for Quick Reply ! Works Fine !

Hambone Over a year ago

@user3007361 -- if pumbo's answer satisfies your original question, please mark it as correct so that future people with a similar problem will know it met your needs

Collectives™ on Stack Overflow

Replace string in postgresql

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related