Re: SQL Loader: variable length records

From: <wliu2_at_my-deja.com>
Date: Fri, 04 Jun 1999 21:39:16 GMT
Message-ID: <7j9h22$olu$1@nnrp1.deja.com>

On Unix, I think you can do something like

awk -F, -vOFS=, '{print $4, $9, $20, $33, $55, $71, $78, $90}' \ input_file > output_file

then run sqlload on output_file.

Wei

In article <375410BA.27D98AA4_at_ix.netcom.com>, CJ <djjr_at_ix.netcom.com> wrote:
> I have a file with 91 variable width fields separated by a ','. My
> problem is that I only
> need 9 of them which are interspersed within the records. For example
> I only want to load fields 4,9,20, 22, 33,55,71,78, and 90. I've been
> looking
> for an example of how to do this but they all assume that you will be
> loading
> every field in the file. How do I select just the fields that I need?
>
> TIA
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jun 04 1999 - 16:39:16 CDT