Removing carriage return characters
387902Feb 17 2003 — edited Feb 17 2003We are trying to export data into an Excel sheet using the SQL tab.
We have a VARCHAR2 column 'Comments' that contains carriage return characters.
We tried to run the sql using the 'replace' functionnality,
that is "replace (comments,chr(10), ' ')" but a new line is still created in the Excel sheet.
We also tried with chr(13).
Do you know how to do to remove these carriage returns?
Thanks for help.
Patrick & Isa.