Postgresql replace numbers after specific letter

Question

I have text strings like the following:

g06, f03, k090

And I would like to remove all zeros that immediately follow a letter. So the output would be:

g6, f3, k90

I can do something like:

select regexp_replace('k090','0','')

But this will replace all 0’s and not just the one immediately following a letter.

Wiktor Stribiżew · Accepted Answer · 2022-07-07 17:51:03Z

1

You can use

SELECT REGEXP_REPLACE('g06, f03, k090', '([[:alpha:]])0+', '\1', 'g')

Here,

The replacement pattern is \1, a replacement backreference to Group 1 value (so it is not removed).

answered Jul 7, 2022 at 17:51

Wiktor Stribiżew

631k41 gold badges502 silver badges632 bronze badges

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

1 Comment

Thanks so much, this is exactly what I’m looking for!