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:

[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

Original text of this message