On 2017-09-21 12:01, Wyatt Zacharias wrote:
So I've got a storage appliance that I'm trying to generate a growth chart on, but the output format of the statistics is not in a usable format.
The output looks like this, with each day of the week in a column, and then 6 rows of data underneath, and then it repeats.
-2- -3- -4- -5- -6- -7- -8- 5827.1 6865.6 3551.2 4649.5 4006.6 15803.5 10305.0 199.4 353.4 175.9 200.7 172.5 584.0 554.2 9.9x 4.4x 6.4x 5.9x 6.3x 5.6x 5.3x 3.0x 4.4x 3.2x 3.9x 3.7x 4.9x 3.5x 29.2x 19.4x 20.2x 23.2x 23.2x 27.1x 18.6x 96.6 94.9 95.0 95.7 95.7 96.3 94.6
-23- -24- -25- -26- -27- -28- -29- 2798.2 2235.3 2357.9 4701.3 9074.3 13796.5 11705.7 86.7 74.1 131.6 178.1 449.3 483.5 473.7 11.4x 12.0x 7.0x 8.1x 3.9x 6.3x 6.7x 2.8x 2.5x 2.6x 3.2x 5.2x 4.6x 3.7x 32.3x 30.2x 17.9x 26.4x 20.2x 28.5x 24.7x 96.9 96.7 94.4 96.2 95.0 96.5 96.0
-30- -31- -1- -2- -3- -4- -5- 2798.6 2274.5 2325.8 2472.1 2526.0 13955.3 11224.2 86.7 88.9 145.2 115.2 105.6 497.9 432.4 10.8x 10.1x 7.4x 8.1x 9.8x 6.2x 6.9x 3.0x 2.5x 2.2x 2.7x 2.4x 4.5x 3.8x 32.3x 25.6x 16.0x 21.5x 23.9x 28.0x 26.0x 96.9 96.1 93.8 95.3 95.8 96.4 96.1
Is there a way I can get awk to process 6 rows of each column at a time?
Not particularly... awk is a single line filter, doing multi-line leads to madness. But you can use the line number to gauge/tract state.
Crappy awk pseudo code...
BEGIN {state counter = 0 } ^- { Line starts with ^- it's a header line, set state counter to 0. } ^[0-9]+ & state counter == 0 { next line starts with a number and state counter is 0 so do first line thing, increment state counter } ^[0-9]+ & state counter == 1 { next line starts with a number and state counter is 1 so do second line thing, increment state counter } ... ^[0-9]+ & state counter == 5 { next line starts with a number and state counter is 5 so last line in the sequence, set counter to 0. } repeat END { output your fancy stats }
You can then use a data structure like an array or a 2d matrix to handle the data you output at the end.
(PS. Yes I know you can nest the stanzas but trying to keep the suggestion clear)
-- Sean