UNIX for Dummies Questions & Answers

goodpeople...
i have following script which collects info from tab and then generates csv file. all is good except 3 digt and 4 digit enties from tab

Issue here is that csv file is not okay with 3 digit and 4 digit entries that reside in tab.

script...

#!/bin/ksh
#
# Script to send secure company codes report to secureCompanies distribution lis
t
#
. ~/.profile 2>/dev/null
cat <<EOF | sqlplus cdromadmin/cdromadmin
set head off
set feed off
set pagesize 5000
set line 12
set sqlprompt ''

spool /CDROM/log/activ_company_tmp.csv
select '="'||t1.company_code||'",="'||t1.region_code||'"' from cdrom_companies t
1, cdrom_passwords t2 where t2.entry_id=t1.password_entry and t2.password_id !=
0 order by t1.region_code , t1.company_code;
spool off

set feed on
quit
EOF
cat /CDROM/log/activ_company_tmp.csv|grep -v select | grep -v '^$' | grep -v spool > /CDROM/log/activ_company.csv
uuencode /CDROM/log/activ_company.csv active$(date +"%m.%d.%H.m").csv | mail -s
"Enabled companies, daily report" secureCompanies
rm /CDROM/log/activ_company_tmp.csv /CDROM/log/activ_company.csv
echo FINISHED


excerpt from csv file
AAA ="999
"
=001""" ="999
9"
002 ="999
9"

Yours is a SQLPLUS problem:

Code:

set colsep ,
set head off
spool file.csv
select 
      '"'|| t1.company_code ||'"'  
      '"'|| t1.region_code ||'"'  
      from cdrom_companies t1, 
             cdrom_passwords t2 
      where t2.entry_id=t1.password_entry and 
            t2.password_id !=0 
            order by t1.region_code , t1.company_code;

Note that COLSEP does what you want basically, and that formatting makes
it possible to see mistakes.

Jim, thnx a ton....seperator works like a charm
I also found what was wrong with my script.... after your response I looked into "set line 12" increased it to a "set line 14" and it's all good to go...

thnx once again