Retrieving numbers from an alphanumeric text file using a bash script

Question

I am outputting the results of a timed executable to a file that has run 10 times. I have all the times in a file, and I need to find the best, worst, and average user times from this file. I was thinking about using a combination of awk to print the first column, but I am unsure how to strip "user" from the line so I can sort it numerically.

Also, I would need to get rid of the even rows, since they have information about the inputs and outputs and things that don't matter to these calculations. A sample of the time file is below:

1.12user 0.00system 0:01.12elapsed 99%CPU (0avgtext+0avgdata 5408maxresident)k
0inputs+0outputs (0major+398minor)pagefaults 0swaps

Does anyone have any idea of how I would do this?

Any help would be appreciated! Thank you.

you can get best,worst,avg in one-shot. updated answer.

Kent
– Kent

2013-02-16 23:58:31 +00:00
Commented Feb 16, 2013 at 23:58 — Kent
– Kent, Commented Feb 16, 2013 at 23:58

Kent · Accepted Answer · 2013-02-16 23:52:54Z

1

is this ok for you?

awk -F'user' 'NR%2{print $1}' file

with an example:

kent$  cat file
1.11user 0.00system 0:01.12elapsed 99%CPU (0avgtext+0avgdata 5408maxresident)k
0inputs+0outputs (0major+398minor)pagefaults 0swaps
1.10user 1.00system 0:01.12elapsed 99%CPU (0avgtext+0avgdata 5408maxresident)k
0inputs+0outputs (0major+398minor)pagefaults 0swaps
1.12user 2.00system 0:01.12elapsed 99%CPU (0avgtext+0avgdata 5408maxresident)k
0inputs+0outputs (0major+398minor)pagefaults 0swaps
1.13user 3.00system 0:01.12elapsed 99%CPU (0avgtext+0avgdata 5408maxresident)k
0inputs+0outputs (0major+398minor)pagefaults 0swaps

kent$  awk -F'user' 'NR%2{print $1}' file
1.11
1.10
1.12
1.13

Even this maybe?

 awk -F'user' 'NR%2{a[++i]=$1;s+=$1}END{asort(a);print "best: "a[1];print "worst: "a[length(a)];print "avg: "s/length(a)}' file

the above example will output:

best: 1.10
worst: 1.13
avg: 1.115

answered Feb 16, 2013 at 23:52

Kent

197k36 gold badges248 silver badges317 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

scoots Over a year ago

Yes! Thanks so much! I will vote up as soon as I have the reputation to do so.

scoots Over a year ago

Is there a way to print best and worst with head and tail after I sort the list, out of curiosity? I thought I got it to work, but each one prints 01 about 10 times. Odd

jim mcnamara · Accepted Answer · 2013-02-16 23:46:02Z

1

tr -s ' '  '[:alpha:]' < inputfile | awk '{print $1, $2, $3} ' > newfile

There other variations to do the same thing.

answered Feb 16, 2013 at 23:46

jim mcnamara

16.5k2 gold badges40 silver badges52 bronze badges

1 Comment

scoots Over a year ago

I tried that, and it returns: tr: when translating, the only character classes that may appear in string2 are upper' and lower' '

sotapme · Accepted Answer · 2013-02-16 23:54:16Z

1

If you're only interested in the initial number #user.

cat txt | paste - - | cut -d' ' -f1  | tr -d "[:alpha:]" | sort -n

gives:

1.12
1.13
1.14
1.15
1.16

on my example of your txt with numbers changed to prove sorting.

answered Feb 16, 2013 at 23:54

sotapme

4,9432 gold badges21 silver badges21 bronze badges

Collectives™ on Stack Overflow

Retrieving numbers from an alphanumeric text file using a bash script

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related