001 对文件某一列求和
awk '{sum += $collum};END {print sum}' /path/to/your/file
2 3
3 5
假设文件内容如上所示:
# awk '{sum += $1};END {print sum}' the-file.txt
5
# awk '{sum += $2};END {print sum}' hhht.txt
8
002 用sort按照文件某列排序
参考如下选项:
-k, --key=POS1[,POS2]
start a key at POS1, end it at POS2 (origin 1)
举例(按照第四列排序):
# cat the-file.txt
22 3 5 6 3
31 5 4 5 4
13 6 7 4 5
13 5 8 3 6
# sort -k4 the-file.txt
13 5 8 3 6
13 6 7 4 5
31 5 4 5 4
22 3 5 6 3
参考:
http://stackoverflow.com/questions/357560/sorting-multiple-keys-with-unix-sort
003 上周一的日期,上个月最后一天的日期
# end=$(date -d "last Sunday" +%Y%m%d)
# date -d "$end -6days" +%Y%m%d
20140728
# end=$(date -d "this month" +%Y%m01)
# date -d "$end -1days" +%Y%m%d
20140731