Re: Eliminating redundant carriage return with SQL*Loader

DA Morgan schrieb:

> Alex wrote:
> > Hi NG,
> >
> > I'm loading Windows-created flatfiles via SQL*Loader into an Oracle
> > 10g-database.
> > But as I had to discover, while loading the files in an Linux
> > environment, there are extra symbols (chr(13)) imported.
> > Those carriage returns are messing up my import procedures...
> > But while not knowing where the flatfiles will be created later on, I
> > have to find a way of handling this character dynamically.
> >
> > Can anyone hint me a solution how to handle these CRs, depended wether
> > they exist (Win-created) or not (Linux/Unix-created)???
> >
> >
> > Any help will be appreciated!
> >
> > Alex Sauer
>
> Strip them out by using the TRIM or SUBSTR function in your SQL*Loader
> control file. An example of putting functions into control files can be
> found in Morgan's Library (www.psoug.org) under SQL*Loader.
> --
> 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

Ouch!
Should have known that !
Guess I'm heading home now... been to long in front of the screen.

Thanks for your answer, I'll do that.

Alex Sauer Received on Fri Oct 13 2006 - 10:23:52 CDT