Regexp_replaces pattern only once

sriramnedunuri — Fri, 28 Mar 2025 16:12:53 GMT

select regexp_replace('asdfhsdf&&1&&asdfasdf&&2&&asdf','&&[0-100]&&','') output

here it replaces first pattern but not the 2nd pattern

o/p

output
asdfhsdfasdfasdf&&2&&asdf

even if we use position its not working something like both wont work

select regexp_replace('asdfhsdf&&1&&asdfasdf&&2&&asdf','&&[0-100]&&','',2) output

select regexp_replace('asdfhsdf&&1&&asdfasdf&&2&&asdf','&&[0-100]&&','',15) output

Re: Regexp_replaces pattern only once

sriramnedunuri — Fri, 28 Mar 2025 16:39:26 GMT

changing to [0-9] works this can be closed.