- 论坛徽章:
- 0
|
比如现在我有1万行如下文本:
09/26/2004 SMDAP1126 161238 485 366 2 32
09/26/2004 CBSDEV02-UX 152242121 5548 2582 4709 36
09/26/2004 SMDAP1120 375711 6938 6691 21 31
09/26/2004 CBSDEV01-UX 84840926 2404 2481 1408 2385
09/26/2004 CBSDEV04SV 344955 25 9 1 0
09/26/2004 SMDAP1127 43878618 1454 215 434 0
09/27/2004 CBSDEV02-UX 181720181 5860 2577 5035 35
09/27/2004 SMDAP1126 175407 2656 234 2 2333
09/27/2004 SMDAP1120 706517 7675 7422 74 31
...........................
我想对文本按第1,2列进行汇总如下:
09/26/2004 SMDAP1126 20303 432321 5423 132 533
09/27/2004 SMDAP1126 30503 433321 1233 132 533
.......
09/26/2004 CBSDEV02-UX 4323 452 123 532
.........
即如果第1,2列相同,对3,4,5,6累加汇总,在数据库中用select from group by很容易实现,可用shell/awk/sed如何实现?
急用,谢谢!!! |
|