| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Replace carriage return with space
A copy of this was sent to madhu.moza1_at_jsc.nasa.gov
(if that email address didn't require changing)
On Wed, 24 Jun 1998 21:43:58 GMT, you wrote:
>I am trying to create comma delimeted file from the oracle database.
>One of the columns in the table has text with carriage returns in it
>When I try to look at the output of the query file from eXcel, the text in
>that column is being treated as separate records. The eXcel file does not
>come out in the right format. I want to replace carriage returns
>with spaces. How will I do it using SQLPLUS functions.
>There is lot of data in the table and is entered by the users.
>
>I need help as how to replace carriage returns in text with spaces.
>
>Thank you
> Madhu Moza
>
select translate( some_column, chr(10)||chr(13), ' ' ) from some_table
that will change Linefeeds (ascii 10) and Carriage returns (ascii 13) into a blank...
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Wed Jun 24 1998 - 20:27:03 CDT
 |
 |