Postgresql Regexp_replace group

Question

Sorry my english

i have this query

select regexp_replace('Hello OBLIG: 451451, world OBLIG: 12123456789, Task OBLIG: 789456123, world ', '(OBLIG: )([^,]*)', '\1\2' , 'g')

I need to return something like this

Hello OBLIG: 1451, world OBLIG: 6789, Task OBLIG: 6123, world

the number after "OBLIG:" should be the last 4 digits

Any idea?

Richard Huxton · Accepted Answer · 2015-06-02 06:30:43Z

2

You were almost there.

select regexp_replace(
    'Hello OBLIG: 451451, world OBLIG: 12123456789, Task OBLIG: 789456123, world ', 
    '(OBLIG: )([[:digit:]]*)([[:digit:]]{4})', '\1\3' ,
    'g'
);

Of course, this assumes you always have at least 4 digits in each number.

answered Jun 2, 2015 at 6:30

Richard Huxton

23.6k5 gold badges43 silver badges53 bronze badges

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

Collectives™ on Stack Overflow

Postgresql Regexp_replace group

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