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!

Question about using REGEXP_REPLACE to replace commas between double quotes

928881Apr 6 2012 — edited Apr 29 2012
Hello,

I have been looking around to try to find a solution to my problem but I would like to use the REGEXP_REPLACE function to do the following:
Original String:
TEXT1,TEXT2,"TEXT3,TEXT4,TEXT5",TEXT6,TEXT7,"TEXT8,TEXT9,TEXT10,TEXT11",TEXT12

Desired String:
TEXT1,TEXT2,"TEXT3 TEXT4 TEXT5",TEXT6,TEXT7,"TEXT8 TEXT9 TEXT10 TEXT11",TEXT12

Could anyone help me accomplish this?

Comments

I think you mean "odd numbered".
Anyway, here is an example:
select * from (select ename,job, ROWNUM AS rn from emp) where mod(rn, 2) <> 0;

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 27 2012
Added on Apr 6 2012
11 comments
8,757 views