How to instruct SQL*Loader to skip first column of semi-colon (;) separated file

Home -> Community -> Usenet -> c.d.o.misc -> How to instruct SQL*Loader to skip first column of semi-colon (;) separated file

From: Ketil Smaaskjaer <ksmaaskj_at_hotmail.com>
Date: Wed, 10 Feb 1999 19:51:00 +0100
Message-ID: <79skbl$fd1$1@romeo.dax.net>

I have a file where the columns are separated by semi-colon (;) and in some cases I would like to skip the first coulumn of the text file.

Is it possible ot instruct SQL*Loader to do this ??

e.g

Col A Number
Col B Date
Col C Varchar2(50)

Text file look like this

1234;02/10/99;This is an example
12350;02/10/99;This is an example
136;02/10/99;This is an example

It is Ok to test that if COL A has a value then Skip ??

Please Reply to

ketil.smaaskjar_at_oslo.itservice.telenor.no Received on Wed Feb 10 1999 - 12:51:00 CST