Does anyone have an example of SQLPlus code to create a delimited file without producing embedded blanks? I've tried several 'set' options - including trimspool - but still get spaces after each column in the output file.

Please copy responses to: greg_pearson@fanniemae.com.

Here's an example of a tab delimited file ... Replace the chr(9) with ','
if you want a comma delimited file ...

set linesize 120
set header off
set pagesize 0
set feedback off
set trimspool on

spool c:\test.txt

select username||chr(9)||sid||chr(9)||serial#||chr(9)||pr ogram from v$session;

spool off

HTH
Gregg

Got it, thanks. In addition to my delimeter, I was using commas in the select string to separate fields.

Glad it worked out ...

Gregg

Oh and if you are on a unix box and want to stip off the padded blanks on the right, you could do the following

spool xyzzy.txt
.......
spool off
host sed -e 's/\ \ *$//' xyzzy.txt >xyzzy.cvs

and regardless of o/s, trimspool serves that exact purpose, so bother with the extra step. I believe trimspool became available in v8, so it might be time to revist those reports you wrote on v7.

Cool, makes my life easier.... Thanks