regexp_replace only captures first instance

Question

I'm trying to remove the two periods from a name like B.J. Smith using regexp_replace(name,'[.]','') but it's only removing the first period. I also tried regexp_replace(player,'([.])','') to no avail.

Does this answer help? Use the occurrences parameter to determine the number of matches to make. — D M
– D M, Commented Feb 7, 2021 at 3:50

sticky bit · Accepted Answer · 2021-02-07 03:55:09Z

2

Use the g flag to replace the matches globally.

regexp_replace('B.J. Smith', '\.', '', 'g')

answered Feb 7, 2021 at 3:55

sticky bit

37.7k12 gold badges34 silver badges46 bronze badges

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

Collectives™ on Stack Overflow

regexp_replace only captures first instance

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related