Hi,
I made a small awk program just to test array variables.
I couldn't find anything wrong with it.
But it doesn't give out valid numbers.( just 0.00 )
Do you see any problem that I didn't see?

Thanks in advance!

Here is the program:

##################################
BEGIN {
FS = ","
}

{
job = $2
station = $3
time_period = substr($6,1,3)
wait= $11
if (station > 0) {
while ( y <=24 ) {
++y
if ( time_period == y ) {
hour[y] += wait
++i[y]
}

}

}
}
END {
y = 0
while ( z <= 24 ) {
++z
++y
if ( i[y] > 0 ) {
AVG[z]=hour[y]/i[y]
printf("%9.2f\n",AVG[z])
}
}
}

###################################

Here is one row of my data file:
17.11.2004,5189400,222,12538476808, 215, 23:51:01, 23:51:14, 23:51:27, 13, 0, 13, d, 1, 0, 20718, (253)847-6, 1303, -1, 23:51:04, 23:51:04, 0, 23, 3, 1, 2, 0, respo, DEL

you don't need to initialize to 0 - awk variables are set to 0 implicitly
why another embedded BEGIN block?
the value of the sixth field is: '23:51:01'
the substring of legth 3 starting from the 1th location is '23:'
This END block will be exucuted ONCE after ALL the records in ALL the files are processed.
Is that what you want?
What are you trying to do - I don't quote folow the logic here?

vgersh99,
Another Begin block is a typo which shouldn't be there.
This program is to print out AVG $11 hourly.
substr($6,1,3) represents hourly time(01 ~24).
I only need $11 field if $3 is greater than 0.
So if $3 > 0 and if substr($6,1,3)=01, then hour[01] += $11;
if substr($6,1,3)=12, then hour[12] +=$11....


At the end block, I need to AVG array "hour[01]" ~"hour[24]" individually and print them out.

I hope I made myself clear.
??

whis is osmething to start with - you can massage the code below based on your own testing/requirements.

nawk -f what.awk myDataFile.txt

what.awk:

I got the problem solved by adding a + 0 at the end of time_period=substr($6,1,3)

time_period = substr($6,1,3) +0


I guess if I don't add +0, the express if evaluated as string and the program will never go to if statement.


Thanks for all the help!!