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

On Tue, 17 Oct 2006 01:37:26 -0700, 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.

select regexp_replace(long_varchar2_column,'\n',' ') from my_table;

-- 
http://www.mladen-gogala.com