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

[Quoted] In your example, the first field 1,234 would be treated as 2 seperate fields [Quoted] because of the comma. If it was "1,234" it would be treated as one field [Quoted] 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 [Quoted] 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
>=================================================================
>
>
>
>
>
Received on Fri May 28 1999 - 10:17:13 CEST