Shell Programming and Scripting

I wrote one script to generate total number of Test cases failures of system as per the host and version .

I want to split number of test cases failures, as per the product .

The logs contain output .

I want to generate output like this


Version Host DB OPC Proxeco Total
7 Eagle 20 10 5 35
7.1 Animator 35 40 2 77
8 Eagle 20 5 4 29


I am posting my scripts and test log also . Please help me to divide it into further part.



_-------------------------------------------------------------------------
#!/bin/sh

#sh gdata.sh /users/testsuite/db/SiCat/

DATE=`date '+20%y-%m-%d'`

for i in /users/testsuite/db/SiCat/$DATE/* ; do

## It generates the total sum of failuers as per the host and productwise .

find $i -name daily -prune -o -name run.log -print -exec grep -c ! {} \;;done > /users/testsuite/db/SiCat/SiCathist/$DATE.log


cat /users/testsuite/db/SiCat/SiCathist/$DATE.log | paste - - | tr "/" " " | cut -d" " -f7,8,9 | sed -e 's/run.log/ /g'> /users/testsuite/db/SiCat/SiCathist/$DATE.log

waiting for reply pls help me

currently it is generating output

7 Animator 50
8 eagle 30
8 Animator 15


but i want to split total number of failuers as per the DB , Proxeco and other

i can hardcord this names in shell scripting .

pls help me

Just a reminder from the forum rules ...

(4) Do not 'bump up' questions if they are not answered promptly. No duplicate or cross-posting and do not report a post where your goal is to get an answer more quickly.

===================================

anyways, post your complete script in between code tags --- the "#" button near the top of the edit box --- to make it look prettier and easier to debug ... also post a sample of your input file data ... people will be able to help you quicker if you help them out ...

... and while you're waiting for a response, read the current threads in the "Unix for Dummies" forum as well as do a search on splitting data in this forum --- it seems to me that a question similar to yours is posted in these forums at least once a week ... good luck!