How to replace new line character in one of the value in CSV during DBMS_CLOUD.COPY_DATA call?
Summary:
This DBMS_CLOUD.COPY_DATA API is failing during importing data from Object storage to ATP that is having a new line characters in one if its value. We are trying to import the CSV file into the ATP database using DBMS_CLOUD.COPY_DATA API.
Content (please ensure you mask any confidential information):
Data file: Having two records in CSV file, second record is split due to new line below -
INSERT_USER,REMARK_QUAL_GID,REMARK_SEQUENCE,UPDATE_DATE,REMARK_TEXT,UPDATE_USER,INSERT_DATE,DOMAIN_NAME,ORDER_RELEASE_GID
"xxxx.user","abc remark qual gid 1",2,,"Remark Text 1",,"2024-08-22T18:30:55Z","ABC","ABC.Order Release ID"
Tagged:
1