Re: SQL*Loader can a comma delimited file be imported and skip selected fields?

In article <374e4ec6.0_at_145.227.194.253>,   "Mark Gumbs" <mgumbs_at_nospam.hotmail.com> wrote:
> In your example, the first field 1,234 would be treated as 2 seperate
fields
> because of the comma. If it was "1,234" it would be treated as one
field
> providing your control file said
>
> fields terminated by ',' optionally enclosed by '"'
>
> As for ignoring fields, i needed to do that a few months ago but
couldn't
> find a way. :-(
>
> M
>
> Jeff Boehlert wrote in message <7ikvbb$c4b$1_at_bashir.peak.org>...
> >All:
> >
> >Is it possible to import a comma delimited file, optionally enclosed
with
> ",
> >variable length fields and ignore select fields?
> >
> >Example file:
> >1,234.56,"123 Elm St",ABC,345
> >2,1000.45,"Main St",A,5
> >
> >Destination table includes only two columns ROW_ID and STREET, to
those
> >columns I want to map fields 1 and 3. Fields 2,4 and 5 are to be
ignored.
> >
> >Thank You,
> >Jeff Boehlert
> >jboehler_at_ctron.com
> >--
> > _ __________________________________________ _
> > / )| Jeff Boehlert boehlert_at_peak.org |( \
> > / / | Why run 26.2 ? | \ \
> > _( (_ | Because it hurts so good !! | _) )_
> >(((\ \>|_/->__________________________________<-\_|</ /)))
> >(\\\\ \_/ / o New York City o \ \_/ ////)
> > \ / < \ Marine Corp < \ \ /
> > \ _/ _/\ Portland _/\ \_ /
> > / / / Big Sur / \ \
> > /___/ Seattle \___\
> > San Francisco
> > Rock-n-Roll Marathon
> >=================================================================
> >Utica, NY home of the best 15k in the country - The Boilermaker
> > And of course the Distance Running Hall of Fame
> >=================================================================
> >
> >
> >
> >
> >
>
>
Don't have the manual with me but how about trying the offset columns option.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sun May 30 1999 - 07:52:25 CEST