Re: SQL Loader Problem

sed "s/.$//g" input_file > output_file

Goran

jazz <J_Le_bru_at_excite.co.uk> wrote in message news:96butt$4ej$1_at_newsg2.svr.pol.co.uk...
> I'm trying to load some datafiles into oracle using sql-loader. Each
> datafile is a .csv file, but the problem is that at the end of each file
 is
> some sort of hidden character. It causes sql-loader to abort with
 message -
> 'partial record found at end of datafile'. (Its not a carriage return but
> in windows its a small square and in unix its a bizarre shape)
>
> I need to get sql-loader to skip past this, or ignore it or something,
 then
> carry on loading the other files
> Anybody know if this this possible in sql-loader? I cant seem to find any
> functionality that'll do this
>
> Failing this - does anyone know a unix command that would be able to
 delete
> the last character from a file?
>
>
>
>
Received on Wed Feb 14 2001 - 16:11:33 CET