Hi All,
I'm doing the following -
declare
vData varchar2(500) := 'A,B,C,D,E,"F, F1",G,H';
vTmp varchar2(100);
begin
select REGEXP_SUBSTR(vData ||',', '([^,]*),|$', 1, 6, NULL, 1)
into vTmp
from dual;
dbms_output.put_line(vTmp);
end;
Result - "F
Desired Result - "F, F1"
Thank You