Re: How to handle varchar(4000) field containing carriage returns in reporting?

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 17 Oct 2006 08:10:52 -0700
Message-ID: <1161097847.918007@bubbleator.drizzle.com>

Carlos wrote:

> Sameer wrote:

>> Hello,
>> I am having a Oracle database, the data in tables of which is being
>> stored using a web application. One of the fields of a table is having
>> varchar(4000) datatype.
>> The data in this field is text which may contain carriage returns also.
>> I have to create a report for this table. How to display this data
>> properly in a report?
>> I tried few things:
>> Accessed the table using SQL Developer and pasted the query output in
>> Excel.
>> As the text contains carriage returns, it is being spread into one or
>> more rows.
>> How to handle this?
>> What is the proper way to create report for such data?
>> Please help.
>> -Sameer

> 
> Maybe REPLACE(your_column, CHR(10), ' ') will do the trick...
> 
> HTH
> 
> Cheers.
> 
> Carlos.

I think:
REPLACE(your_column, CHR(10), NULL)
might work a bit better.

But best to make sure it is really CHR(10) and not some other character.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Tue Oct 17 2006 - 10:10:52 CDT