Re: SQL*LOADER: Skipping over fields in text file?

Hi Roberto,
your solution is true if you're working with fixed field lengths.
If the columns are tab-delimited, as was the question, then you have to include in your controlfile something like:
FIELDS DELIMITED BY CHR(9). cheers.

Roberto wrote:
>
> Try this :
> -- 1 2 3
> -- 123456789012345678901234567890123456789012345678901
 234567890
> -- John Doe JUNK FIELD1 JUNK FIELD2 123 Halloween Drive
> -- Mary Smith MORE JUNK EVEN MORE 567 Street Road
> ABOVE IS COMMENTED OUT JUST FOR REFERENCE...
>
>
> LOAD DATA INFILE 'names.dat'
> insert into addresses (
> Name position(001-012) char,
> Address position(039-050) char )
>
> Be VERY specific when defining the positions.This numbering system at
> the top can be extremely useful. Loader will only load what YOU tell
> it to and ignores everything else. Goodluck, Rob
>
> reynolds_at_monet.cs.athabascau.ca (James Reynolds) wrote:
>
> >I'm new to using SQL*Loader, and am having some trouble importing
> >selected fields from tab-delimited ASCII files.
 

> >For example, my Oracle table contains two columns:
 

> >Name varchar2(20)
> >Address varchar2(20)
 

> >While the text file looks like this (4 columns):
 

> >John Doe JUNK FIELD1 JUNK FIELD2 123 Halloween Drive
> >Mary Smith MORE JUNK EVEN MORE 567 Street Road
 

> >I've tried various settings in the control file with no luck. Can anyone
> >shed some light? Thanks in advance.
 

> >Jim.
  Received on Thu Nov 07 1996 - 00:00:00 CET