Re: SQL*LOADER - Question

Juan Carlos Rodriguez wrote:
>
> Hello !
>
> I have a problem loading data with SQL*LOADER.
> The datafile to load has 4 variable length fields terminated by commas.
> I only need two fields but they aren't contiguous.
>
> For example, supose this data file:
> 1,"one","first","A"
> 2,"two","second","B"
> 3,"three","third","C"
> ....
> We only need the columns 1 and 3, discarding the columns 2 and 4.
>
> Any suggestion ?

if you are using unix, you can

$ mknod pipe p
$ cut -d"," -f1,3 < data.txt >> pipe

and then you specify pipe as your input file. i dont recommend that more than one process writes into that pipe, that could mess up your data. Received on Tue Aug 04 1998 - 15:29:51 CEST