文本中的文件格式如下所示:
08,12,,SettlementSta.20070801.0001.591.591,,20070801173747,20070801173755,,,0
04,12,,SettlementSta.20070801.0001.591.591,,20070801173747,20070801173755,,,0
01,12,,SettlementSta.20070801.0002.028.028,,20070801173755,20070801173901,,,227599
03,12,,SettlementSta.20070801.0002.028.028,,20070801173755,20070801173901,,,227599
08,12,,SettlementSta.20070801.0002.028.028,,20070801173755,20070801173901,,,0
04,12,,SettlementSta.20070801.0002.028.028,,20070801173755,20070801173901,,,0
01,12,,SettlementSta.20070801.0002.471,,20070801173901,20070801173902,,,1096
03,12,,SettlementSta.20070801.0002.471,,20070801173901,20070801173902,,,1096
08,12,,SettlementSta.20070801.0002.471,,20070801173901,20070801173902,,,0
04,12,,SettlementSta.20070801.0002.471,,20070801173901,20070801173902,,,0
01,12,,SettlementSta.20070801.0002.591.591,,20070801173902,20070801173912,,,34263
03,12,,SettlementSta.20070801.0002.591.591,,20070801173902,20070801173912,,,34263
08,12,,SettlementSta.20070801.0002.591.591,,20070801173902,20070801173912,,,0
04,12,,SettlementSta.20070801.0002.591.591,,20070801173902,20070801173912,,,0
01,12,,SettlementSta.20070801.0002.851.851,,20070801173912,20070801173915,,,10304
03,12,,SettlementSta.20070801.0002.851.851,,20070801173912,20070801173915,,,1030
08,12,,SettlementSta.20070801.0002.851.851,,20070801173912,20070801173915,,,0
04,12,,SettlementSta.20070801.0002.851.851,,20070801173912,20070801173915,,,0
用下面的語句可以統計出該文件中的第十個字段的總和,文件名為
fck_fmt3.0.20070801235617
awk -F, '{(tot+=$10)}; END{print "total number :" tot}' fck_fmt3.0.20070801235617
但是有個問題是,如果數值過大的話,系統將會用科學計數法來進行表示,可以將其進行拆分來解決
posted on 2007-08-02 00:49
LG 閱讀(448)
評論(0) 編輯 收藏 引用 所屬分類:
UnixProgram