能给出一个计算时间差和匹配某个字段的shell吗？

lqiao

一个文件如test.txt，格式如下：
a,b,c,20051201180903,20051201180912,d,e,21/122,21
a,b,c,20051201180903,20051201180912,d,e,f,21/121,21,22
a,b,c,20051201180903,20051201180912,d,e,f,g,21/121,21,22,23
其中第4列和第5列都是时间，格式为YYYYMMDDHHMMSS，需要提取第5列减第4列差为大于60s，并且包含21/121的列，请问这个shell该如何写？

lqiao

如果第5列减去第4列为大于20s的，那如何判断呢？谢谢！

大蚂蚁

原帖由 lqiao 于 2005-12-20 11:36 发表
如果第5列减去第4列为大于20s的，那如何判断呢？谢谢！

基础12中的awk篇幅中应该有讲的

mocou

1. awk -F, '$0~/21\/122/{a=substr($4,1,4)" "substr($4,5,2)" "substr($4,7,2)" "substr($4,9,2)" "substr($4,11,2)" "substr($4,13,2);b=mktime(a);aa=substr($5,1,4)" "substr($5,5,2)" "substr($5,7,2)" "substr($5,9,2)" "substr($5,11,2)" "substr($5,13,2);bb=mktime(aa);cc=bb-b;if (cc>20)print}' file

复制代码

谁给个简化的

寂寞烈火

思路简单,解决起来比较繁琐

大蚂蚁

原帖由 mocou 于 2005-12-20 14:05 发表

1. awk -F, '$0~/21\/122/{a=substr($4,1,4)" "substr($4,5,2)" "substr($4,7,2)" "substr($4,9,2)" "substr($4,11,2)" "substr($4,13,2);b=mktime(a);aa= ...

复制代码

域分割符号怎么不取大点？
取

1. －F ",200512011"

复制代码

如何？或者更长点？

waker

1. gawk -F , '/21\/121/{a=$4;b=$5;gsub(/../,"& ",a);
   
2. gsub(/../,"& ",b);
   
3. sub(/ /,"",a);
   
4. sub(/ $/,"",a);
   
5. sub(/ /,"",b);
   
6. sub(/ $/,"",b);
   
7. if(mktime(b)-mktime(a)>60)print} ' file
   

复制代码

如果你要求的差值都是xxs的话(注意，如果要求的差值大于小时的话，结果是什么俺没想)

1. 
   
2. awk -F , '/21\/121/&&(substr($5,1,12)-substr($4,1,12))*60+(substr($5,13,2)-substr($4,13,2))>60 ' file
   

复制代码

寂寞烈火

原帖由 mocou 于 2005-12-20 14:05 发表
[code]awk -F, '$0~/21\/122/{a=substr($4,1,4)" "substr($4,5,2)" "substr($4,7,2)" "substr($4,9,2)" "substr($4,11,2)" "substr($4,13,2);b=mktime(a);aa= ...

汗,,,,,, :em11:

寂寞烈火

/home/lee#cat txt
a,b,c,20051201180603,20051201180912,d,e,21/122,21
a,b,c,20051201180902,20051201180913,d,e,f,21/121,21,22
a,b,c,20051201180904,20051201180914,d,e,f,g,21/121,21,22,23

1. 
   
2. /home/lee#cat f
   
3. #!/bin/bash
   
4. ifs=$IFS
   
5. IFS=','
   
6. while read line;do
   
7. set -- $line
   
8. a=$(date +%s -d"${4:0:8} ${4:8:2}:${4:10:2}:${4:12:2}")
   
9. b=$(date +%s -d"${5:0:8} ${5:8:2}:${5:10:2}:${5:12:2}")
   
10. c=$((b-a))
    
11. echo $@ $c
    
12. done<txt|awk '$NF>60&&/21\/122/{gsub(/ /,",");sub(/,([0-9])+$/,"");print}'
    

复制代码

result

/home/lee#sh f
a,b,c,20051201180603,20051201180912,d,e,21/122,21
/home/lee#