Sure, use a tool that converts data to hex codes, and recognizes that when data is reloaded. Typically (for USASCII7 data) anything less < char(32) and > char(127) would be converted to hex. Try googling for such a tool. You might check and see if DataBee does this. HTH Jared On 11/16/05, d cheng <dc4oracle@xxxxxxxxx> wrote: > > 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. > > > > > > > > > -- > //www.freelists.org/webpage/oracle-l > > > > ------------------------------ > Yahoo! FareChase - Search multiple travel sites in one > click.<http://us.lrd.yahoo.com/_ylc=X3oDMTFqODRtdXQ4BF9TAzMyOTc1MDIEX3MDOTY2ODgxNjkEcG9zAzEEc2VjA21haWwtZm9vdGVyBHNsawNmYw--/SIG=110oav78o/**http%3a//farechase.yahoo.com/> > > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist