with t as
(select ',,,ASS' as c1 from dual union all
select 'DOG,,,' from dual union all
select ',,CAT,,' from dual union all
select ',,B,GH,J,,K,,' from dual union all
select '",",CA,T","' from dual)
select trim(both ',' from c1) from t
Above query returning the double quote
ASS
DOG
CAT
B,GH,J,,K
",",CA,T","
Need to remove leading and trailing double quote and comma.
Please help me with a common function to remove them