Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to achieve below using REGEXP_REPLACE

Nikhil MahajanSep 15 2018 — edited Sep 16 2018

I want output below

Input-

a, b, c(a, b, c), d, e(a, b), f

Output-

a,, b,, c(a, b, c),, d,, e(a, b),, f

How above output can be achieved using REGEXP_REPLACE

Single comma’s present within brackets, should not replace with double comma

PLEASE NOTE - in single string there can be multiple set within brackets, in this example i have only shown 2..

THANK YOU SO MUCH

This post has been answered by Solomon Yakobson on Sep 15 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 14 2018
Added on Sep 15 2018
#plsql, #sql
9 comments
1,934 views