[求助]一组数据整理办法

seesea2517

你目前做到哪里，有啥问题可以发出来，大家讨论讨论。
如果没有头绪，建议用 awk 试试。

seesea2517

我也觉得是这样的。

1. [seesea2517@UC ~] $awk -F"," '{sum[$7,$8]+=$13; if(! ($7 SUBSEP $8 SUBSEP $2 in ar)) count[$7,$8]++; ar[$7,$8,$2]++} END{for(i in sum) print gensub(/[^0-9]/, "-", "x", i) " : " sum[i] " : " count[i]}' file
   
2. 898-0762 : 40 : 1
   
3. 220-022 : 42 : 2
   
4. 898-0898 : 12 : 1
   
5. 
   
6. [seesea2517@UC ~] $cat file
   
7. 20,13016236390,0,0,0,0,898,0898,9999999999,,2,0,6,0,0,0,0
   
8. 21,13016240088,0,0,0,0,898,0762,9999999999,,2,0,20,0,0,0,0
   
9. 24,13032256323,0,0,0,0,220,022,9999999999,,2,0,21,0,0,0,0
   
10. 20,13016236390,0,0,0,0,898,0898,9999999999,,2,0,6,0,0,0,0
    
11. 21,13016240088,0,0,0,0,898,0762,9999999999,,2,0,20,0,0,0,0
    
12. 24,xxxxxxxxxxx,0,0,0,0,220,022,9999999999,,2,0,21,0,0,0,0

复制代码

seesea2517

回复 6# reyleon


    其实lz表达的还算好了。