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
Received on Fri Oct 13 2006 - 09:53:44 CDT
