Xref: alice comp.databases.oracle.server:39517
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!howland.erols.net!infeed.is.co.za!feeder.is.co.za!hermes.is.co.za!not-for-mail
From: "Billy Verreynne" <vslabs@onwe.co.za>
Newsgroups: comp.databases.oracle.server
Subject: Re: SQLLoader and CR/LF in data
Date: Tue, 2 Feb 1999 10:29:53 +0200
Organization: Verreynne Software Labs
Lines: 23
Message-ID: <796d5t$2dc$1@hermes.is.co.za>
References: <36B6433E.11558820@netscape.net>
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4

Jerry B. wrote in message <36B6433E.11558820@netscape.net>...
>
>Is there any way to import files containing CR/LF in the data?


Use the FIX parameter in the Control File - this is assuming that the
data is fixed length. If memory serves me, the syntax is something like
this:
LOAD DATA
INFILE '*' FIX '320'
INTO ...rest of the control file header..

If you're loading variable length which has CR/LFs in the data then you
have a problem. SQL*Loader needs to know -where- a row terminates. Best
then is to load the data file into a hex editor and to (hopefully) find
exactly what unique character is used as end-or-row terminator.

regards,
Billy