对某个字段求平均值

sulaimani_yu

<httpSample t="332" lt="332" ts="1393225455257" s="true" lb="10" rc="200" rm="OK" tn="/hotel 1-34" dt="text" by="252"/>
<httpSample t="354" lt="354" ts="1393225455324" s="true" lb="10" rc="200" rm="OK" tn="/hotel 1-135" dt="text" by="252"/>
<httpSample t="452" lt="452" ts="1393225455295" s="true" lb="10" rc="200" rm="OK" tn="/hotel 1-105" dt="text" by="252"/>
<httpSample t="511" lt="511" ts="1393225455271" s="true" lb="10" rc="200" rm="OK" tn="/hotel 1-29" dt="text" by="252"/>
<httpSample t="515" lt="515" ts="1393225455269" s="true" lb="10" rc="200" rm="OK" tn="/hotel 1-82" dt="text" by="252"/>
<httpSample t="568" lt="568" ts="1393225455269" s="true" lb="10" rc="200" rm="OK" tn="/hotel 1-83" dt="text" by="252"/>
<httpSample t="586" lt="586" ts="1393225455257" s="true" lb="10" rc="200" rm="OK" tn="/hotel 1-44" dt="text" by="252"/>
<httpSample t="667" lt="667" ts="1393225455252" s="true" lb="10" rc="200" rm="OK" tn="/hotel 1-55" dt="text" by="252"/>
<httpSample t="861" lt="860" ts="1393225455257" s="true" lb="10" rc="200" rm="OK" tn="/hotel 1-46" dt="text" by="10421"/>
<httpSample t="895" lt="893" ts="1393225455254" s="true" lb="10" rc="200" rm="OK" tn="/hotel 1-60" dt="text" by="10643"/>
<httpSample t="896" lt="894" ts="1393225455264" s="true" lb="10" rc="200" rm="OK" tn="/hotel 1-72" dt="text" by="10378"/>
<httpSample t="937" lt="937" ts="1393225455267" s="true" lb="10" rc="200" rm="OK" tn="/hotel 1-31" dt="text" by="12981"/>

想对  t   这个字段的值求平均值

有什么简便的方法么？

谢谢

关阴月飞

1. awk -F\" '$1~/t=/{s+=$2;n++}END{print s/n}' urfile

复制代码

这个冬天不冷

1. awk -F "[=\"]" '{sum=sum+$3}END{print sum/NR}' a

复制代码

yestreenstars

1. awk -F\" '{s+=$2}END{print s/NR}'

复制代码

wslm31

cat xxxx.xx|awk -F"\"" '{printf $2 " "}'|awk '{for(i=1;i<=NF;i++)(sum+=$i)(avg=sum/NF);printf avg "\n"}'

elu_ligao

awk -F\" '{s+=$2}END{print s/n}'