SQL*Loader. 1 Datafile in several Tables???

[Quoted] My task is to load a huge file into a database. The file should end up in serveral tables. The file has delimited fields in it. I cannot find a way to address a specific field other than the first one in an import record.

A sample Import file might look like this one

	nID
	,
	sText
	)

INTO TABLE imp2
FIELDS TERMINATED BY ','
(

	nID Position(1) -- reposition on first field
	, 
	sText2 -- should be 3rd field but is always the 2nd 
	)

1,aXXXXXXXXXXX,z
2,bXXXXXXXX,x
3,cXXXXXXX,y
4,dXXXXXXXXXX,w
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Is there any way to skip a field in the import file or to address it by field number rather than by character number.
The only alternativ seems to be to change the import file.

Thanks for your help. Received on Tue Jun 17 1997 - 00:00:00 CEST