removing CR/LF from data file extracted from SQL

[josem]

Is there any way to prevent SQL putting a CR/LF at the end of the record when it is written to a spooled file ?

I need to extract a number of records to a file, but I need o end up with one long record made up of many concatenated data records.

or is it possible to remove the CR/LF from unix ? and how ?

any help is appreciated.

 

[moulab3]

Hi,
If I understood this, you have a unix file, and you'd like to remove cr/lf from from the end
of each line of the file.
If so: you do that vi your_file
tape escape before
:s $//g ----> this will apear on the bottom of the screen
the mean of this operation:
s substitute
$ the end of the line
// by nothing
g global
make a copy of your file and do that.

Bye.

lat.am@netcourrier.com