SQL*Load delimited fields

From: <eweber_at_bdo.com>
Date: Tue, 25 Aug 1998 21:51:24 GMT
Message-ID: <6rvbks$6eg$1@nnrp1.dejanews.com>

I am trying to use SQL*LOAD to load a file of delimited data, but I do not want every field to be loaded into the database. For example my input data looks like this:

cat,dog,banana,elephant,monkey,bone,peanuts

But I only want to load "monkey" and "banana" into my table of two columns.

I can't seem to find the syntax to do this. Is it possible? Or do I have to right some type of parser to eliminate the unwanted fields before I attempt the SQL*LOAD?

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Aug 25 1998 - 16:51:24 CDT