Eliminating redundant carriage return with SQL*Loader

From: Alex <dead.man.walking_at_gmx.de>
Date: 13 Oct 2006 07:03:07 -0700
Message-ID: <1160748187.688096.229920@k70g2000cwa.googlegroups.com>

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