SQLLoad and varying number of fields

From: Norman Wehrle <nwehrle_at_web.de>
Date: 15 Jan 2001 18:19:34 GMT
Message-ID: <93vevm$bh5gn$2_at_ID-23610.news.dfncis.de>

Hi,

I have to import a file similar to the following syntax with sqlload:

  TI: 18th Annual Colloquium on Clinical Dermatology   TE: Congress

  DA1:  17.1.2001
  LO1:  Maui
  LO2:  Hawaii: Four Seasons Resort
  LO3:  USA

  CP: Dermatology Foundation,1560 Sherman Avenue, Suite 870,Evanston, IL 60201,USA
  FX: (847) 328-0509
  TL: (847) 328-2256 Countryphone: +1
  SBT1: Medicine
  SBT2: Dermatology
#

  TI: 3rd JSMRM International Symposium: "Seeing the Insight of Nuclear Magnetic Resonance (NMR) in Biomedicine"   TE: Congress and Exhibition

  DA1:  20.1.2001
  DA2:  21.1.2001
  LO1:  Tokyo
  LO2:  Japan
  LO3:  Nihon Toshi Center

  CP: JSMRM 2001 - Secretariat,3rd Fl. YU Bldg,3-19-6 Hongo, Bunkyo- ku,Tokyo, 113-0033,Japan

  FX:  +81 3 5684 1650
  TL:  +81 3 5684 1636
  EM:  QYP06456_at_niftyserve.or.jp
  UL:  http://wwwsoc.nacsis.ac.jp/jmrm
  SBT1: Imaging
  SBT2: Magnetic Resonance Imaging

  SBT3: Biology
  SBT4: Biochemistry/Molecular Biology
#

As you can see, in the first record there are 11, in the second one 16 fields. The string before the colon is the fieldname in the database. Records are separated by hashes. Is it possible to write a appropriate control file for sqlload or should i program a perl-script for that purpose? Thanks.

-- 
Norman Wehrle

Received on Mon Jan 15 2001 - 19:19:34 CET