Re: Skipping variablye-length fields with sql*loader

In article <3b55c9a3$0$28394$6e365a64_at_newsreader02.highway.telekom.at>, "Wolfgang says...
>
>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";;;;
>
>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:
>

see
http://osi.oracle.com/~tkyte/SkipCols/index.html

it goes over the options based on version (which sigh, are missing from this post)

>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
>
>
>
>

--
Thomas Kyte (tkyte_at_us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp