Re: SQLLDR / CSV problem

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 12 Jul 2006 08:25:27 -0700
Message-ID: <1152717929.287963_at_bubbleator.drizzle.com>


blindsey wrote:
> I'm trying to load some client data in CSV format using SQLLDR.
>
> The problem is that the text fields in the data contain CRLFs which
> SQLLDR can't tell from record-ending CRLFs.
>
> Before I go off trying to write one myself, is there some sort of
> utility which would recognize that a CRLF is within a field's enclosing
> characters and strip it out or replace it with something else?
>
> Or another way to solve the problem?

What version of Oracle?
Loading into what data type?
Look at the CONTINUEIF syntax.

-- 
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 Wed Jul 12 2006 - 17:25:27 CEST

Original text of this message