Skipping variablye-length fields with sql*loader

[Quoted] [Quoted] I've got an automatically generated list. Its fields are separated by semicolons:

1098;"Graber Jürgen";"05442";"64674";"Flieáerau 373";;"Fliess";"6521";;;;
1272;"Küchl Franziska";"0664";"4825179";"Aigling
29";;"Oberperfuss";"6173";;;;
1355;"Tilg Silvia";"05232";"81071";"Wiesgasse 1G";;"Oberperfuss";"6173";;;;

[Quoted] [Quoted] I need to insert field 7 and 8 into a table. If there weren't the six leading fields the solution for the control file would look like that:

LOAD DATA
INTO TABLE Localita
FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"'   (
  Locali_K CHAR(40),
  CapLoc CHAR(5)
  )

How can I skip the leading fields?

Thanks so far

     Wolfgang Received on Wed Jul 18 2001 - 19:39:26 CEST