Re: sqlldr - ignore columns?

Russell England wrote:
>
> I have several csv files that I want to load, but the csv files have some
> columns that I want to ignore:
>
> LOAD DATA
> INFILE *
> INTO TABLE mytable
> FIELDS TERINATED BY "," OPTIONALLY ENCLOSED BY '"'
> (Field1,Field2,,Field3,Field4)
> BEGINDATA
> "keep","keep","lose","keep","keep"
> "keep","keep","lose","keep","keep"
> ...
>
> How can I ignore the middle column?
>
> Thanks in advance
>
> Russ

In 8i+ you can skip columns in SQL Loader - check the doco on the SKIP clause. In earlier versions, (if you are on unix), a little creative use with awk, cut et. al can modify the file before applying to sqlldr.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse