multiple-line csv import

From: Ralf <Threepwood.Guybrush_at_gmx.de>
Date: 7 Jul 2003 07:56:32 -0700
Message-ID: <71cfc7f.0307070656.3122f03d@posting.google.com>

Hi,
I try to import a CSV file to a Oracle database using the SQL*Loader. My problems are multiple-line text fields. Example:

   ID;NAME;INFO;GENDER
   1;James;"My new butler,
   a lame guy";male
   2;Fry;"The pizza guy,
   what a man!";male

The control file looks like this:

LOAD DATA
  INFILE 'c:\dev\import_.csv'
  APPEND
  INTO TABLE wais
  FIELDS TERMINATED BY ';'
  TRAILING NULLCOLS
(
  ID INTEGER,

  NAME CHAR TERMINATED BY ';',
  INFO CHAR TERMINATED BY ';' ENCLOSED BY '"',
  GENDER CHAR TERMINATED BY ';'

)

CONTINUEIF could be the solution, but I didn't find out how to use it correctly.

Thanx in advance.

Ralf Received on Mon Jul 07 2003 - 09:56:32 CDT