triming whitespace from output of select * ...

I need to do some exporting of data. What i do is set colsep |
spool fileout.txt
select * from sometables where etc. etc. spool off

Problems: there are too many white spaces between each of the fields in the output file. How do I get rid of these whitespaces. I would like to do this in the sqlplus select statement if possible.

Forgive me if this is a faq. Havent' really got a chance to get a copy of the faq. Received on Mon Nov 26 2001 - 11:33:46 CST