Thank you Vikas! Vikas Gautam <g_vikas@xxxxxxxxxxx> wrote: We put our record seperator as a chr(111) or some unprintable character in the unload and the load and that solved the ^M problem. Vikas ----- Original Message ----- From: "Stephane Faroult" To: Cc: Sent: Wednesday, November 16, 2005 8:08 AM Subject: Re: Unload Table Data to Flat Files > David, > > Can't you apply a replace(colname, chr(10), chr(32)) to your varchar2 > columns ? > It should (normally) fix the issue. > > HTH > > Stéphane Faroult > > On Wed, 2005-11-16 at 04:31 -0800, d cheng wrote: >> Hi Listers, >> >> I need to unload several large database tables unto flat files on a >> Unix database server. I am using Tom Kyte's SQL*Plus unloader. >> However, there seems to be a problem when a varchar column contains a >> ^M (CR) within it. All other columns to the right of this are >> truncated and missing from the record in the flat file. Is there a >> way to workaround this truncation issue? I would like to NOT scrub >> the data by removing the carriage return as the end-users might expect >> them to be there. >> > > >> > > > -- > //www.freelists.org/webpage/oracle-l > > > -- //www.freelists.org/webpage/oracle-l --------------------------------- Yahoo! FareChase - Search multiple travel sites in one click.