Shell Programming and Scripting

Yes, Just because a value isn't a min value doesn't mean its max, don't know what I was thinking there.

If the input file had been sorted with:
sort -o B.txt -k1,1 -k2,2n B.txt
which could be true with the sample input shown, your code would work just fine. In fact, the three lines in your code:

Code:

  if(!($1 in M)) M[$1]=X[$1]=$2
  else if($2<M[$1]) M[$1]=$2
  else X[$1]=$2

could be simplified even more to just:

Code:

  if(!($1 in M)) M[$1]=$2
  X[$1]=$2

Thanks guys. Just got a couple of follow-ups:

1. Let's say I want to add one more column counting the number of pings per address. That would only be to add c[i], right?

2. Would it be possible to describe briefly what happens here?

Code:

if(!($1 in c)) m[$1] = M[$1] = $2
	else	if($2 > M[$1]) M[$1] = $2
	else	if($2 < m[$1]) m[$1] = $2

Then I can edit the file myself so it fits other types of files I'm working on.

Cheers!
Z

Code:

	if(!($1 in c)) m[$1] = M[$1] = $2	# 1st line with this IP? Set min & Max for this IP
	else	if($2 > M[$1]) M[$1] = $2	# else, if new Max for this IP, save it
	else	if($2 < m[$1]) m[$1] = $2	# else, if new min for this IP, save it

Thanks again Don. Just put this code in a bash script and I would like to be able to specify the input file as an argument. So I would like to call:

Code:

./stats.sh B.txt

for example. Tried to change "B.txt" in the file to various things (like $1 but that's already in use in the file...). What would do the trick?

What happened when you replaced the filename operand to awk in stats.sh with $1?

That should be OK. The $1 in an awk script expands to the contents on the 1st first field in the current input line, but the $1 in a shell script expands to the contents of the 1st command line argument passed to that shell script.

You're right of course. The problem was that I used a script editor and got the line ending wrong. Fixed that with:

Code:

sed -i 's/\r//' stats.sh

Ok, the topic has derailed a bit, but here is the final one: if I also add a third column with the URL for each IP in the input file (B.txt), how can I print that in the final table? Tried to add:

name[$1] = $3

Assuming that this would set the variable 'name' for a certain IP address to the URL listed in column 3 in the infile. So if this is a row in the infile:

Code:

62.147.28.224  12  www.myserver.com

The output file would get one more column to the right with www.myserver.com. But it just prints zero (0) for me in that column.

Promise this is the last one in this thread ;-)