Re: Problem with input ASCII files
From: <hparks_at_mlock.com>
Date: 1998/04/01
Message-ID: <6fug75$qbq$1_at_nnrp1.dejanews.com>#1/1
Date: 1998/04/01
Message-ID: <6fug75$qbq$1_at_nnrp1.dejanews.com>#1/1
In article <351F76AE.E4ECC146_at_geru.ucl.ac.be>,
Thib <Philippart_at_geru.ucl.ac.be> wrote:
> Top of ASCII file
> \ |
> \ file created by: CREATOR | header
> \ date of creation: 22/03/98 |
>
> For example, the aim is to read CREATOR and put this word in another
> column, called column_3
> With SQL*Loader, I can only read columns of data.
>
Use something like:
when (3:17) = 'file created by'
( column_3 position(20:30) )
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Apr 01 1998 - 00:00:00 CEST