sql*loader question

Is it possible to skip columns (fields) when using delimited records?

[Quoted] For instance, I have table T with columns A and B but the file I am loading from has data like

aaaaa, ccc, bbbbbbbbbb
aa, ccccccc, bbbbbbb
[Quoted] aaaaaaaaaa, cccc, bbbbbbb
...

INTO TABLE T
  fields terminated by "," (
    A,
    ???,
    B
  )

What do I put instead of ??? to skip ccc, ccccccc, and cccc fields in first, second, and third records respectively?

Note that the fields are variable-width, so I can't use position.

Thanks.
k& Received on Fri Jan 22 1999 - 20:46:34 CET