Awk - using an array with multiple files

Question

I'm new to shell scripting, and I need to compute an average file1, and then the average of the result and a number in file2, so far i came up with this, but it doesn't print anything.

awk '{if ($FILENAME == "spring") array[$1]=($2+$3+$4+$5+$6+$7+$8)/7; if($FILENAME == "fall") array[$1]=(array[$1]+$2)/2 }  END { for (var in array) print var,array[var]}' ./spring ./fall

Any way to solve this problem?

To get a decent answer you need to post both files and the output you expect. — Chris Seymour
– Chris Seymour, Commented Mar 29, 2013 at 16:21

Chris Seymour · Accepted Answer · 2013-03-29 16:26:13Z

1

How about awk '{s+=$1}ENDFILE{print FILENAME,s/FNR;s=0}' RS=" " file1 file2:

$ cat file1
1 2 3 4 5 6 7 8

$ cat file2
1 2

$ awk '{s+=$1}ENDFILE{print FILENAME,s/FNR;s=0}' RS=" " file1 file2
file1 4.5
file2 1.5

answered Mar 29, 2013 at 16:26

Chris Seymour

86.4k32 gold badges166 silver badges209 bronze badges

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

Comments

William Pursell · Accepted Answer · 2021-06-11 18:14:29Z

1

There are no sigils in awk. Try dropping the $:

awk 'FILENAME ~ /spring/ { array[$1]=($2+$3+$4+$5+$6+$7+$8)/7 }
   FILENAME ~ /fall/ { array[$1]=(array[$1]+$2)/2 }  
   END { for (var in array) print var,array[var]}' ./spring ./fall

In short, FILENAME is the name of the file currently being processed, but $FILENAME is equivalent to $0 when FILENAME starts with a letter.

edited Jun 11, 2021 at 18:14

answered Mar 29, 2013 at 16:22

William Pursell

214k49 gold badges279 silver badges317 bronze badges

2 Comments

Walter A Over a year ago

FILENAME is including the path, so FILENAME == "./spring".

William Pursell Over a year ago

@WalterA Good catch. Not sure how an answer can go this long with such an error! Editing to be slightly more robust

Collectives™ on Stack Overflow

Awk - using an array with multiple files

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related