Re: sqlldr - ignore columns?

From: Yong <yhuang_at_indigopool.com>
Date: Mon, 28 Aug 2000 11:56:36 -0500
Message-ID: <8oe5q9$hpj$1@news.sinet.slb.com>

Have a look at
http://osi.oracle.com/~tkyte/SkipCols/index.html Basically, there's no built-in function in SQL*Loader to do what you need (except when the positions are fixed). My favorite tool Perl would be used if I were you.

Yong Huang
yhuang_at_indigopool.com

Russell England <russ_at_css2.com> wrote in message news:JJOp5.2857$NR3.435877_at_news1.cableinet.net...
> I have several csv files that I want to load, but the csv files have some
> columns that I want to ignore:
>
> LOAD DATA
> INFILE *
> INTO TABLE mytable
> FIELDS TERINATED BY "," OPTIONALLY ENCLOSED BY '"'
> (Field1,Field2,,Field3,Field4)
> BEGINDATA
> "keep","keep","lose","keep","keep"
> "keep","keep","lose","keep","keep"
> ...
>
> How can I ignore the middle column?
>
> Thanks in advance
>
> Russ
>
>
Received on Mon Aug 28 2000 - 11:56:36 CDT