Search Results

@RavinderSingh13, sorry to reply late. I did try the same code and input as you used. And I only get:
site Date time value1 value2
No any data coming out.

@Rudic, I really appreciate your help. Now the first code works but with another issue: I just realize the date isn't continuous for some sites. e.g.
0023 2014-01-01 21:00 90.0 20
0023 2014-01-01...

Thank you, Runic and Don Cragun, I had tried the new code as suggested, but there is a problem. If I use the new input as below:010730023 2014-06-30 07:00 78.0 21.8081
010730023 2014-06-30 08:00...

RudiC, thank you. I had edited that as suggested. Here is the output I got when I use bash
awk: division by zero
input record number 1, file input
source line number 12

@Mr. Cragun and Ravinder, thank you for help!

After I switch to bash, I did get some output with the limited input I gave. However, there is problem using the input below:

site Date time value1...

@RavinderSingh13, I got error message when I tried to test your script:

% awk 'NR==1{print;next} {split($3,...

@RavinderSingh13, thank you so much for help. However I got error "previous: Event not found." I tried to search "awk keyword previous", but didn't get anything helpful. Would you please explain it...

Hello all, I am working on a file like below:

site Date time value1 value2
0023 2014-01-01 00:00 32.0 23.7
0023 2014-01-01 01:00 38.0 29.9
0023 2014-01-01 02:00 85.0 26.6
0023 2014-01-01 03:00...

(https://www.unix.com/members/28161.html) (https://www.unix.com/members/28161.html)Thank you so much, Cassj and Franklin52! I used csh (#!/bin/csh) before and always got error (Unmatched '). Now I...

Thank you for your time, Franklin52. I am using linux here. I had tried everything I can think of with both awk and gawk (we don't have nawk). But still get same error. Did I miss sth?

Everything looks fine to me now, but I keep getting error message as below:

awk: ./hr_2_davg.awk:3: awk -F, '
awk: ./hr_2_davg.awk:3: ^ invalid char ''' in expression

Thank you very...

Sorry I don't know much about awk , but I still got error as below:
awk: hr_2_davg.awk:3: awk -F, '
awk: hr_2_davg.awk:3: ^ invalid char ''' in expression

Thank you so much for help!

Sorry, I guess I didn't make my question clear. I want to get the DAILY average output for each day in each month for each site, instead of one average output for each site. The format should look...

Thank you so much for quick response. But should I define "i" somewhere first? I got error message as below:

awk: $4>0{a[$1]+=$4;b[$1]++}END{for i in a}{print "Average for " i " = " a[i]/b[i]}...

Hi

I am looking for an awk script which can compute the average of the last column based on the date and time. The file looks:

site1,"2000-01-01 00:00:00", "2000-01-01 00:59:00",0.013...