awk 'BEGIN {count=0;revsum=0;bdnum=1;click = 0;} {if($1!=0){bdid[count,0]=$1; bdid[count++,1]=$9;}; dis_bdid[0]=bdid[0,0]}
END{
for(i=0;i<count;i++)
{
for(j=0;j<bdnum;j++)
{
if (bdid[i,0]== dis_bdid[j])
{
break;
}
}
if (j==bdnum)
{
dis_bdid[bdnum++]=bdid[i,0]; click+=bdid[i,1];
}
print i" "bdid[i,0]};
print "rvcsum:" count;
print "bdnum:" bdnum ;
print clickuv: ”click;
}' part-0504-00000
END{
for(i=0;i<count;i++)
{
for(j=0;j<bdnum;j++)
{
if (bdid[i,0]== dis_bdid[j])
{
break;
}
}
if (j==bdnum)
{
dis_bdid[bdnum++]=bdid[i,0]; click+=bdid[i,1];
}
print i" "bdid[i,0]};
print "rvcsum:" count;
print "bdnum:" bdnum ;
print clickuv: ”click;
}' part-0504-00000