Re: Can you load a comma delimitted text file into a table. but only take specified columns??

Home -> Community -> Usenet -> c.d.o.misc -> Re: Can you load a comma delimitted text file into a table. but only take specified columns??

From: Raffaello Galli <galli_at_harry.molgen.mpg.de>
Date: Tue, 9 Jul 2002 10:52:14 +0200
Message-ID: <Pine.OSF.4.31.0207091051330.1006-100000@harry.molgen.mpg.de>

On Mon, 8 Jul 2002, Anus wrote:

> I have a really big comma delimted text file, with lots of fields
>
> ( example - 30 Fields)
>
> but all i want to do is take field8, field15, and and field16
>
>
> I know i could parse the file with awk or perl to have a uniform text
> file,
>
> but i was wondering if SQL*Loader has a way to specify certain columns
> to be obtained from the text file???

If I remember right, it should be easily possible.

> ( remember - it is comma delimited NOT a Position text file )

Raffaello Received on Tue Jul 09 2002 - 03:52:14 CDT