loading selected cols via sql loader

[MGoel]

Hello All,

I want to load a tab delimited data file using sql loader.
But in that file there are many cols(fields) which i don't want to load, how can i specify that in the ctrl file?

Also within some fields they have '|' as the separator and I want to load the first set of characters. say for e.g.
the data is like this abc@xyz.com | def.wer@rtu.com in one the fields.

I want to load only the abc@xyz.com.

Anticipating to hear soon from you all .

Thanks

Manoj

 

[THoey]

Someone else may have a better answer, but why not load all of the data using SQL*Loader into a staging table and then run a APPEND query to pull the data you want from that staging table into your active table? Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...