Hi Guys
I need help removing some lines from output i am receiving from a shell script.
Here is the output:
I am trying to remove the output that i have circled.
. ${EDW}/extracts/bin/extracts_setup2.sh
. ${EDW}/extracts/extracts.conf
date_f=`date +%Y%m%d`
DATADIR=/extracts/
OUTFILE=article.$date_f ; rm -f $OUTFILE
OUTFILEgo=article$date_f ; rm -f $OUTFILEgo
isql -U${USER} -P${PASSWD} -S${SERVER} > ${DATADIR}${OUTFILE} << EOF
go
select rtrim(departmentDescr)+ ','+ rtrim(categoryDescr)+ ','+ rtrim(brandDescr)+ ','+
convert(varchar,barcode)+ ','+ convert(varchar,uot)+ ','+ convert(varchar,skuId)+ ','+ rtrim(uotDescr)+ ','+
rtrim(convert(varchar,convert(int, uomQty))||uomDescr)
from DBA.DimProduct, DBA.BarcodeUot
where uot = unitOfTradeId
and uotDescr not like 'DISCONTINUED%'
and divisionDescr in ('FOODS', 'HARDS','SOFTS','PERISH')
order by departmentDescr, categoryDescr, skuId
go
EOF
cd ${DATADIR}
echo 'Department Description,Category Description,Brand Description,Barcode,Unit Of Trade,Sku Id,Unit Of Trade Description,Unit Of Measurement Qty' >>$OUTFILEgo
cat $OUTFILE |sed '/^$/d;/affected/d;s/ *$//' >> $OUTFILEgo
sed '
s/|$//g
s/"//g ' $OUTFILEgo > $OUTFILE
mv $OUTFILE $OUTFILEgo
gzip -9 $OUTFILEgo
cat $OUTFILE |grep -v 'rows affected' >> $OUTFILEgo
rm -f $OUTFILE
rm -f $OUTFILEgo
Thanks :rolleyes: