Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-28-2025 09:12 AM
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
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
