averaging specific column of multiple files

view full story

http://www.unix.com – Hi all, I'm needing help again on scripting. I have weekly files with 3 columns, and I need to do monthly averaging on the values on column 3, the file naming convention is as follows: Code: 20000105.u- 2000:year 01:month 05:day 20000112.u 20000119.u 20000126.u 20000202.u 20020209.u I need to do a loop that will read the month part of each filename and do the average of column 3 for all the files falling on the same month. the desired output will be something like: Code: 200001.u containing 3 columns still: cols.1 & 2: the values are the same for all files and so just need to ap (HowTos)