Re: SQL Loader Question

You can pre-process the file in unix, something like:

tr '\001' ',' < inputfile | tr '\002' '\n' > outputfile

This will replace your char(001) with , and your char(002) with a newline, you can then sqlload outputfile as a standard CSV file

benlag_at_aent.com wrote:
>
> Unfortunately this process will not be done manually. An ftp script
> will pick up the file and load it automatically.
>
> Thanks for your help,
>
> Benny
>
> In article <8pt93q$nru$1_at_nnrp1.deja.com>,
> alistair.thomson_at_sphinxcst.co.uk wrote:
> > Just a thought.
> >
> > Can you open this file in a spreadsheet and save it as a CSV file, it
> > would be much easier to handle.
> >
> > alistair.thomson_at_sphinxcst.co.uk
> >
> > In article <8pqsdt$8p$1_at_nnrp1.deja.com>,
> > benlag_at_aent.com wrote:
> > > I am currently using Oracle version 8.0521 on a HP-UX11 system and
 have
> > > a SQL*Loader question.
> > >
> > > I am trying to load a sequential file that contains 3 columns with
 the
> > > column delimiter being a ASCII char(001) and the line delimiter
 being
 a
> > > ASCII char(002). I cannot change the structure of the file (I have
 to
> > > load using these delimiters). The field delimiter is not a problem
 but
> > > I am having problems telling SQL*Loader which character is the line
> > > delimiter. How can I tell SQL*loader how to load this file??
> > >
> > > The following is record from the actual file:
> > > D 64 Artistic Style B Surrealism
> > >
> > > Any help or suggestions would be greatly appreciated,
> > >
> > > Benny Lago
> > > Alliance Entertainment, Inc.
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> > >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Sep 18 2000 - 14:49:58 CDT