Oracle Database Discussions

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!

ASCII CODE REPLACEMENT FOR ENTER ?

510345Jul 13 2006 — edited Jul 13 2006

I have data coming back from oracle that contains a symbol | |, when I double click the row entry in toad it displays it in two lines. So I am assuming this is a CR or LF.
When I export the data to excel it still shows this CR symbol.

How can I remove this or replace this so that it does nto display. For instance

SELECT blah FROM myTable

blah is a text field that may contain a cr / lf. How do I replace this query with something that eliminates the || (CF / LF) from blah ?

Thanks,
Jon

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 10 2006

Added on Jul 13 2006

#general-database-discussions

2 comments

604 views