SQL Loader...how to skip fields in data file

[sajeev]

Hi

I've a data file delimited by ~

a~b~c~d~e

and i'm loading the file into a table X with columns
cola
colb
colc
cole.
Here I don't want to load the data d into my table. I want to skip the filed d of the data file and load data e into the column cole.
Please suggest me , how to achieve this. I can't change the format of the datafile
Thanks,

[jrpm]

In your control file you can specify the locations of the field to be loaded. Just don't specify 'd'. It is easier in fixed format files than CSVs, but check the docs.

[sajeev]

Ican't specify the field position in control file. The table doen'thave any column like that. And its not a fixed length format..

[jrpm]

Look at example 5-5 in the documentation (Using Filler Fields.)

[sajeev]

That's it.. It worked.
Thanks