topic Shell Script Assistance in Operating System - HP-UX

Shell Script Assistance

KAMARULZAMAN HJ ALI — Mon, 04 Jul 2005 07:35:33 GMT

Hi All,

Need some Shell expertise help.
I have input file that contain 2 fields(started date & Size).
input file example:
Started Kbyte
29/6/05 9000
29/6/05 1000
29/6/05 4000
30/6/05 2000
30/6/05 7000

How could I total-up the Size(Kbyte) group by Started field.

TQ.

Re: Shell Script Assistance

Kasper Hedensted — Mon, 04 Jul 2005 08:10:34 GMT

two quick (& dirty?) solutions:

sum=0
grep -v Kbyte |awk '{print $2}'|while read num
do
sum=$((sum+num))
done
echo $sum

or

echo `grep -v Kbyte | awk '{printf $2;while (getline) { printf "+"$2; }}'` | bc

Cheers

Re: Shell Script Assistance

Kasper Hedensted — Mon, 04 Jul 2005 08:18:15 GMT

Ups, you need to sort the dates first

dates=`grep -v ^Started |awk '{print $1}' |sort -u`

for date in $dates
do
sum=0
grep ^$date | awk '{print $2}'| while read num
do
sum=$((sum+num))
done
echo $date $sum
done

Re: Shell Script Assistance

Peter Nikitka — Mon, 04 Jul 2005 10:21:30 GMT

Hi,

try this:

awk 'NR==1 {unit=$2;next}
{s+=$2}
END {printf("%s %s\n,s,unit)}' inputfile

mfG Peter

Re: Shell Script Assistance

Peter Nikitka — Mon, 04 Jul 2005 11:18:50 GMT

Hi,

to add the date:

awk 'NR==1 {unit=$2;next}
{s+=$2; date=$1}
END {printf("%s %s %s\n,date,s,unit)}' inputfile

Re: Shell Script Assistance

curt larson_1 — Mon, 04 Jul 2005 11:49:08 GMT

cat yourFile |
awk '
NR=1 {print $0;next;}
{a[$1]=+$2;}
END {
for ( i in a ) print i, a[i];
} | sort -n

Re: Shell Script Assistance

KAMARULZAMAN HJ ALI — Tue, 05 Jul 2005 10:38:16 GMT

Thanks All,

Another enhancement to the script,

How do I produce the output like this :

Started Kbyte Total
29/6/05 9000
29/6/05 1000
29/6/05 4000 14000
30/6/05 2000
30/6/05 7000 9000

TQ

Re: Shell Script Assistance

Rodney Hills — Tue, 05 Jul 2005 12:50:46 GMT

Try-

awk 'prev1!=$1{if (NR > 1) printf " %s",s;prev1=$1;s=0};END{printf " %s\n",s};{s=s+$2;printf "\n%s",$
0}'

HTH

Rod Hills

PS- Assign points as your peers have helped you...