with t as
(select '"QZY170309001",2487,"UT",1,"JAJAJ02731","test data, is ,for reference, Nomorevalid..","K","Q"' as str
from dual
)
select regexp_replace(str, '("[^",]+),([^"]*")', '\1\2\3' ) from t ;
Hi,
We have to remove all commas inside double quotes . I have tried above query . it is removing from only first position.
Please let me know how to remove all the comma values
Expected output:
"QZY170309001",2487,"UT",1,"JAJAJ02731","test data is for reference Nomorevalid..","K","Q"