#AWK#统计总体折扣设置的情况

#!/bin/awk -f


#判断每个客户设置几个折扣
#根据;的个数，统计有几天设置折扣，即day=length(timea)
#根据,的个数，统计一天设置几个折扣,number=length(time_hour)


BEGIN{FS="\t"
for (i=1;i<=10;i=i+1)
array[i]=0}


{
split($5,timea,";");
day=length(timea);


for(char in timea)
{
split(timea[char],time_hour,",")
number_a += (length(time_hour))
}


array[int(number_a/day)]++


number_a=0
}


END {
for(i=1;i<=10;i=i+1)
print i,":","\t",array[i]

}