Shell Programming and Scripting

Hi All,

I have a file abc.xls which contains data
applciation usage
merlin 24000
hermes 48000

and my script generates an output to a file def.xls
applciation usage
merlin 23000
hermes 50000
Daily i want to schedule this script to run and I need the second column to be appended to the file abc .xls
the output would be like
applciation usage usage
merlin 24000 23000
hermes 48000 50000
next day...
applciation usage usage usage
merlin 24000 23000 2300012
hermes 48000 50000 2300098
etc....


How can i implement this can any one pls suggest

Thanks very much in advance

---------- Post updated at 03:04 PM ---------- Previous update was at 02:52 PM ----------

The scripts which I tried for the above are as follows
szur0849pap:merlinprd% cat Prod_Huffs.sh
#!/bin/ksh
. /home/gaddamja/Huffs_Report.sh >>/home/gaddamja/Temp1
cat /home/gaddamja/Temp1 | awk '{print $1}' >>/home/gaddamja/def.txt

szur0849pap:merlinprd% cat Prod_Huffs_Status.sh
#!/bin/ksh
cd /home/gaddamja
paste def.txt >>/home/gaddamja/abc.xls
echo "Hi All,\n">>/home/gaddamja/Temp
echo "PFA Prod huffs usage as of now( `date`):">>/home/gaddamja/Temp
echo "\n\n\nRegards,">>/home/gaddamja/Temp
echo "Jagadish.">>/home/gaddamja/Temp
/usr/bin/uuencode Prod_Huffs_Utilisation.xls Prod_Huffs_Utilisation.xls >>/home/gaddamja/Temp
cat /home/gaddamja/Temp | /usr/ucb/mail -s "Huffs Report" jagdish-chandra-bose.gaddam@ubs.com
rm Temp

have you tried 'join' (see 'man join') ?

I got it with the below,Its working

redirecting it to a file and renaming the output file with the same file for next days run

#!/bin/ksh
cd /home/gaddamja
paste Prod_Huffs_Utilisation.xls Temp2 >/home/gaddamja/Prod_Huffs_Utilisation1.xls
echo "Hi All,\n">>/home/gaddamja/Temp
echo "PFA Prod huffs usage as of now( `date`):">>/home/gaddamja/Temp
echo "\n\n\nRegards,">>/home/gaddamja/Temp
echo "Jagadish.">>/home/gaddamja/Temp
/usr/bin/uuencode Prod_Huffs_Utilisation1.xls Prod_Huffs_Utilisation.xls >>/home/gaddamja/Temp
cat /home/gaddamja/Temp | /usr/ucb/mail -s "Huffs Report" jagdish-chandra-bose.gaddam@ubs.com
mv Prod_Huffs_Utilisation1.xls Prod_Huffs_Utilisation.xls
rm Temp


But again my doubt is why not
paste Prod_Huffs_Utilisation.xls Temp2 >/home/gaddamja/Prod_Huffs_Utilisation.xls is working..

cant we redirect the output to same file in unix ?

thanks n advance