Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Removing carriage return characters

387902Feb 17 2003 — edited Feb 17 2003
We 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 17 2003
Added on Feb 17 2003
1 comment
617 views