How to remove double quotes from pipe delimited CSV file in Oracle HCM BI report?
For example: HCM BI Report
In Report other than CSV format, it shows:
NAME DISPLAY_NAME LANGUAGE
AAAAA AAAAA, BBBBBB AMERICAN
In the CSV output, it shows:
NAME,DISPLAY_NAME,LANGUAGE
ABBBB|"AAAAA, BBBBB"|AMERICAN
In CSV output, we know oracle will include double quote by default, where it has speacial characters or spaces in between column data.
How I can remove the double quotes in the above CSV output example.
If there is any default setting needs to be changed, please mention it here.