Shell Programming and Scripting

Bloke, at least one step ahead with the statement, no matter whether or not the format looks floating point, hexadecimal, it works fine this part of the if-else-if-ladder. (sorry for the term bloke :-) The solution for me: regex.

Code:

awk '$4 ~ /^Juni$/  {if ($2>max) max=$2; ++n; s+=$2}  END { print "Maximum\t" (max), "Average\t" (s/n)};' datafile.txt

I am very glad to hear that you have solved your problem. (Even though I don't see anything here that is at all related to trying to convert abbreviated month names to unabbreviated month names that seemed to be the focus of the first post in this thread.)

The script you have shown us as your solution, will produce absolutely no output with the sample input you provided (since Juni did not appear anywhere in your sample input).

And, the maximum and average your script is printing is not the maximum and average of the values in field 2 of the matched lines! For example, with your code:

Code:

awk '$4 ~ /^Juni$/  {if ($2>max) max=$2; ++n; s+=$2}  END { print "Maximum\t" (max), "Average\t" (s/n)};' datafile.txt

and datafile.txt containing:

Code:

webster    2:48, 29.06.2014 Juni
webster    3:50, 29.06.2014 Juni
webster   10:59, 29.06.2014 Juni

you get the output:

Code:

Maximum	3:50, Average	5

even though the maximum is 10:59 instead of 3:50, and the average of 2 hours 48 minutes, 3 hours 50 minutes, and 10 hours 59 minutes is 5.8721666666 hours (5 hours, 52 minutes, and just under 20 seconds) instead of exactly 5 hours.

Of course, I already provided you with a function to convert strings of the form hh:mm, to an integral number of minutes (see awk last n lines of file) which you can add together and divide to compute averages and I provided examples to print those averages as hours, minutes, and seconds or as a floating point number of minutes. If you wanted hours, you could easily divide the minutes by 60.

I hope this helps you get what you want. Since you have refused to ever show us the output you wanted to produce in either of these threads, and since you don't seem to find my comments helpful, I won't be replying to any more of your posts.