Thank you for your suggestion. I am hesitant to scrub the chr(10) as it might change user's view of the data. The 'set wrap on' seemed to work ok except it produces an extra blank line - a side effect of setting wrap on?. Any suggestions on overcoming this extra blank line? Stephane Faroult <sfaroult@xxxxxxxxxxxx> wrote: 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. > > -- http://www.freelists.org/webpage/oracle-l --------------------------------- Yahoo! FareChase - Search multiple travel sites in one click.