Spooling Tab Delimited Text - Excess spaces

[cd972]

I am successfully spooling a tab delimited text file in my sql script. The only issue I am having is the spool file contains unnecessary spaces. I'm assuming this method does not trim off this excess and I'm wondering if there is a way to do this, within the script. I have a user running a .bat file to generate this.

Here is a snip-it of what I'm using to generate this...
col TAB# new_value TAB NOPRINT
select chr(9) TAB# from dual;
set colsep "&TAB"
SPOOL c:\&mmddyy..txt
SELECT

 

[BJCooperIT]

In SQL*Plus, TRIMSPOOL determines if trailing spaces are trimmed from lines spooled to a file. Could it be that you have it set on?


[sup]Beware of false knowledge; it is more dangerous than ignorance.[/sup][sup] ~George Bernard Shaw[/sup]
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
My website: www.EmuProductsPlus.com