Grepping a file for Text going down.

keysorsoze · 01-17-2007, 08:02 AM

Hi! I am looking for a way to process info from a file from top down. For example

15:45:01 CPU %user %nice %system %iowait %irq %soft %idle intr/s
15:46:01 all 2.63 0.00 0.16 0.53 0.00 0.02 96.66 1141.81
15:47:01 0 6.92 0.00 0.36 0.52 0.01 0.07 92.11 376.26
15:48:01 1 1.26 0.00 0.09 0.72 0.00 0.00 97.94 256.74
15:49:01 2 1.39 0.00 0.12 0.78 0.00 0.00 97.70 254.60
15:50:01 3 0.94 0.00 0.06 0.10 0.00 0.00 98.90 254.21

How would I process the values for %soft straight down so I can get just a listing of 0.02, 0.07, 0.00, 0.00, 0.00 in a column format.
If I use awk how do I process the field since it is a random number.

Such as

awk '/15.46:01/ {print $8}' system_statistics | less will give me the value of that single line. How do I go about processing the entire column without specifying individual lines.

Thanks.

nx5000 · 01-17-2007, 08:28 AM

I have some problem to understand your question

Quote:

Originally Posted by keysorsoze

How would I process the values for %soft straight down so I can get just a listing of 0.02, 0.07, 0.00, 0.00, 0.00 in a column format.
If I use awk how do I process the field since it is a random number.

Where is there a random number?

Quote:

Such as

awk '/15.46:01/ {print $8}' system_statistics | less will give me the value of that single line. How do I go about processing the entire column without specifying individual lines.
Thanks.

Mmmh
awk '{print $8}'
?

For column treatment there is also /usr/bin/colrm

unSpawn · 01-17-2007, 08:32 AM

...and w/o awk:

Code:

cat output | while read line; do 
 line=(${line}); case "${line[7]}" in 
  [0-9]*) echo "${line[7]}";; esac
done

keysorsoze · 01-17-2007, 09:06 AM

Thanks for the reply, I have obtained what I needed with your awk '{print $8}' command. However, I get a ton of values. How do I narrow them down to just a specific value such as the %idle cpu rate. I tried awk '{print $8}' | grep %idle but all I get is %idle %idle %idle. The goal is to just obtain the field:
%idle statistics.
96.66
92.11
97.94
97.70
98.90

This is a snapshot of a server for every 5 minutes so the file is huge

Here are the awk results:

awk '{print $8}'

%idle
96.66
92.11
97.94
97.70
98.90

TX-ERR
0
BMRU
BMRU
BMRU
BMRU
BMRU
BMRU
0

wkB/s
65.91

wkB/s
289.93

wkB/s
270.20