sudo zcat $fullpath | sudo awk '
BEGIN { FS="@#@" }
NF != 24 { err = sprintf("%s:%d: skipped: NF != 24\n", "'"$filename"'", FNR);
print err > "/var/log/error.log" ; next }
{
split($6,a," ");
date=a[1];
hour=substr(a[2],1,2);
cnt[date"@#@"hour"@#@"$17"@#@"$16"@#@"$22"@#@"$18"@#@"$5"@#@"$23"@#@"$24"@#@"$19"@#@"$4]++;
sum[date"@#@"hour"@#@"$17"@#@"$16"@#@"$22"@#@"$18"@#@"$5"@#@"$23"@#@"$24"@#@"$19"@#@"$4] += $14
}
END
{
for ( key in cnt )
{ print key"~`~"cnt[key]"~`~"sum[key];}
}
'
> $dirname"rts/"$filename.temp