UNIX for Dummies Questions & Answers

Could someone tell me how I can simplify the script that follows!!!
I know that there must be a way how to

grep Average from sar01..................
sar02 .......................
sar03.......................
sar04 and output it to its own file.

My intention is to collect data for the whole month and place in an Excel graph, to monitor how my system worked for the month,



grep Average sar01 > Avgrep01.txt
grep Average sar02 > Avgrep02.txt
grep Average sar03 > Avgrep03.txt
grep Average sar04 > Avgrep04.txt
grep Average sar05 > Avgrep05.txt
grep Average sar06 > Avgrep06.txt
grep Average sar07 > Avgrep07.txt
grep Average sar08 > Avgrep08.txt
grep Average sar09 > Avgrep09.txt
grep Average sar10 > Avgrep10.txt
grep Average sar11 > Avgrep11.txt
grep Average sar12 > Avgrep12.txt
grep Average sar13 > Avgrep13.txt
grep Average sar14 > Avgrep14.txt
grep Average sar15 > Avgrep15.txt
grep Average sar16 > Avgrep16.txt
grep Average sar17 > Avgrep17.txt
grep Average sar18 > Avgrep18.txt
grep Average sar19 > Avgrep19.txt
grep Average sar20 > Avgrep20.txt
grep Average sar21 > Avgrep21.txt
grep Average sar22 > Avgrep22.txt
grep Average sar23 > Avgrep23.txt
grep Average sar24 > Avgrep24.txt
grep Average sar25 > Avgrep25.txt
grep Average sar26 > Avgrep26.txt
grep Average sar27 > Avgrep27.txt
grep Average sar28 > Avgrep28.txt
grep Average sar29 > Avgrep29.txt
grep Average sar30 > Avgrep30.txt
grep Average sar31 > Avgrep31.txt


###########

head -1 Avgrep01.txt > Avhead01.txt
head -1 Avgrep02.txt >> Avhead01.txt
head -1 Avgrep03.txt >> Avhead01.txt
head -1 Avgrep04.txt >> Avhead01.txt
head -1 Avgrep05.txt >> Avhead01.txt
head -1 Avgrep06.txt >> Avhead01.txt
head -1 Avgrep07.txt >> Avhead01.txt
head -1 Avgrep08.txt >> Avhead01.txt
head -1 Avgrep09.txt >> Avhead01.txt
head -1 Avgrep10.txt >> Avhead01.txt
head -1 Avgrep11.txt >> Avhead01.txt
head -1 Avgrep12.txt >> Avhead01.txt
head -1 Avgrep13.txt >> Avhead01.txt
head -1 Avgrep14.txt >> Avhead01.txt
head -1 Avgrep15.txt >> Avhead01.txt
head -1 Avgrep16.txt >> Avhead01.txt
head -1 Avgrep17.txt >> Avhead01.txt
head -1 Avgrep18.txt >> Avhead01.txt
head -1 Avgrep19.txt >> Avhead01.txt
head -1 Avgrep20.txt >> Avhead01.txt
head -1 Avgrep21.txt >> Avhead01.txt
head -1 Avgrep22.txt >> Avhead01.txt
head -1 Avgrep23.txt >> Avhead01.txt
head -1 Avgrep24.txt >> Avhead01.txt
head -1 Avgrep25.txt >> Avhead01.txt
head -1 Avgrep26.txt >> Avhead01.txt
head -1 Avgrep26.txt >> Avhead01.txt
head -1 Avgrep27.txt >> Avhead01.txt
head -1 Avgrep28.txt >> Avhead01.txt
head -1 Avgrep29.txt >> Avhead01.txt
head -1 Avgrep30.txt >> Avhead01.txt
head -1 Avgrep31.txt >> Avhead01.txt


###########


sed '/^$/d' Avhead01.txt | nawk -F " " '{print $2,$3,$4,$5}' > sarcpu_btl-main.txt

###########




head -12 Avgrep01.txt | tail -1 > Avhead02.txt
head -12 Avgrep02.txt | tail -1 >> Avhead02.txt
head -12 Avgrep03.txt | tail -1 >> Avhead02.txt
head -12 Avgrep04.txt | tail -1 >> Avhead02.txt
head -12 Avgrep05.txt | tail -1 >> Avhead02.txt
head -12 Avgrep06.txt | tail -1 >> Avhead02.txt
head -12 Avgrep07.txt | tail -1 >> Avhead02.txt
head -12 Avgrep08.txt | tail -1 >> Avhead02.txt
head -12 Avgrep09.txt | tail -1 >> Avhead02.txt
head -12 Avgrep10.txt | tail -1 >> Avhead02.txt
head -12 Avgrep11.txt | tail -1 >> Avhead02.txt
head -12 Avgrep12.txt | tail -1 >> Avhead02.txt
head -12 Avgrep13.txt | tail -1 >> Avhead02.txt
head -12 Avgrep14.txt | tail -1 >> Avhead02.txt
head -12 Avgrep15.txt | tail -1 >> Avhead02.txt
head -12 Avgrep16.txt | tail -1 >> Avhead02.txt
head -12 Avgrep17.txt | tail -1 >> Avhead02.txt
head -12 Avgrep18.txt | tail -1 >> Avhead02.txt
head -12 Avgrep19.txt | tail -1 >> Avhead02.txt
head -12 Avgrep20.txt | tail -1 >> Avhead02.txt
head -12 Avgrep21.txt | tail -1 >> Avhead02.txt
head -12 Avgrep22.txt | tail -1 >> Avhead02.txt
head -12 Avgrep23.txt | tail -1 >> Avhead02.txt
head -12 Avgrep24.txt | tail -1 >> Avhead02.txt
head -12 Avgrep25.txt | tail -1 >> Avhead02.txt
head -12 Avgrep26.txt | tail -1 >> Avhead02.txt
head -12 Avgrep27.txt | tail -1 >> Avhead02.txt
head -12 Avgrep28.txt | tail -1 >> Avhead02.txt
head -12 Avgrep29.txt | tail -1 >> Avhead02.txt
head -12 Avgrep30.txt | tail -1 >> Avhead02.txt
head -12 Avgrep31.txt | tail -1 >> Avhead02.txt


##########

sed '/^$/d' Avhead02.txt | nawk -F " " '{print $2,$3}' > sarmem_btl-main.txt


##########



rm Av*.txt

Try this.

Code:

#! /bin/ksh

typeset -ZR2 day=1

while (($day <= 31))
do
grep Average sar${day} > Avgrep${day}.txt
day=$(($day+1))
done

sed '/^$/d' Avhead01.txt | nawk -F " " '{print $2,$3,$4,$5}' > sarcpu_btl-main.txt

day=1
while (($day <= 31))
do
head -1 Avgrep${day}.txt >> Avhead01.txt
sed -n -e '12p' Avgrep${day}.txt >> Avhead02.txt
day=$(($day+1))
done

sed '/^$/d' Avhead02.txt | nawk -F " " '{print $2,$3}' > sarmem_btl-main.txt

rm -f Av*.txt

Not tested.

Vino

Will try and inform if works,

Thanks for your time

Jair

Thanks man,

I modified it just a little because it was not finding Avhead01.
It was just the position of the sed request.

I then added a couple ftp commands to my laptop.

Grateful,

Jair