SQL*Loader can a comma delimited file be imported and skip selected fields?
From: Jeff Boehlert <boehlert_at_peak.org>
Date: Thu, 27 May 1999 22:32:13 -0700
Message-ID: <7ikvbb$c4b$1_at_bashir.peak.org>
All:
Date: Thu, 27 May 1999 22:32:13 -0700
Message-ID: <7ikvbb$c4b$1_at_bashir.peak.org>
All:
[Quoted] [Quoted] Is it possible to import a comma delimited file, optionally enclosed with ", [Quoted] 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 [Quoted] 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 - 07:32:13 CEST
