Re: SQL Loader and delimited fields

Try this for your control file:

load data infile 'flatfile.dat'
into table tablename
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"' (field1,field2,field3,field5)

--
Tom Mettling
WT Chen & Company, Inc.
mettling_at_volpe.dot.gov


Geoff wrote:



> Does anyone know how to skip a field when using SQL*Loader and a delimited


> flat file?  I have a file with 5 fields per record.  The fields vary in

> length between records, so I must use a delimited file format.  My table has

> 4 columns, and I need to load the first three fields into into the first

> three columns, but the fifth field must go into the fourth column.  How can

> I skip the fourth field?

>

> Thanks in advance!