处理一个文件内时间差转换成天数

毛线浅爱

想将该文件的第四列 的时间 减去第三列的时间  时间差变换成天数 输出到第五列中，菜鸟求指导，研究了好久  都没研究成功

tuyajie

那个本来应该有很多人会玩玩的，结果你给了个图~~~换成代码吧~~

毛线浅爱

回复 2# tuyajie

[ismp@SMP11 zhong]$
[ismp@SMP11 zhong]$ awk -F '|' '{print$1"|"$2"|"$3"|"$4}' 1.txt
13400041414|18702652237|20150302131949|20150302132312
13400041414|15052124614|20150107111304|20150302131709
13400041414|18279684920|20150302133159|20150313092141
13400041414|14779568524|20150316062001|20150316063117
13400041414|15103434017|20150119152514|20150313092146
13400041414|18479343074|20150316061904|20150316062042
13400041414|13405761414|20150316063544|20150316063639
13400041414|18870680194|20150316060912|20150316061428
13400041414|14762010034|20150105110754|20150115104932
13400041414|15152494334|20141230100609|20141230101153
13400643973|13400644513|20150515154622|20150515155231
13400644913|13489937792|20150519111937|20150609144721

文件类似于这样的  多谢


   

lifayi2008

1. awk 'function pr(b){return substr(b,0,4)" "substr(b,5,2)" "substr(b,7,2)" "substr(b,9,2)" "substr(b,11,2)" "substr(b,13,2)}BEGIN{FS=OFS="|"}{a=mktime(pr($4))-mktime(pr($3));$5=int(a/86400)"d"int(a%86400/3600)"h"int(a%86400%3600/60)"m"a%60"s"}1' test.txt
   

复制代码

笨办法

毛线浅爱

回复 4# lifayi2008
哈哈  多谢了，笨办法总比没有办法好，网友还是强大的

   

haooooaaa

回复 1# 毛线浅爱


这个是错的.... 正确的在后面

yestreenstars

1. import datetime
   
2. 
   
3. with open('input.txt') as f:
   
4.     for each_line in f:
   
5.         each_line = each_line.rstrip()
   
6.         fields = each_line.split('|')
   
7.         d1 = datetime.datetime.strptime(fields[2], '%Y%m%d%H%M%S')
   
8.         d2 = datetime.datetime.strptime(fields[3], '%Y%m%d%H%M%S')
   
9.         diff = d2 - d1
   
10.         fields.append(str(diff.days))
    
11.         print '|'.join(fields)

复制代码

result:

1. 13400041414|18702652237|20150302131949|20150302132312|0
   
2. 13400041414|15052124614|20150107111304|20150302131709|54
   
3. 13400041414|18279684920|20150302133159|20150313092141|10
   
4. 13400041414|14779568524|20150316062001|20150316063117|0
   
5. 13400041414|15103434017|20150119152514|20150313092146|52
   
6. 13400041414|18479343074|20150316061904|20150316062042|0
   
7. 13400041414|13405761414|20150316063544|20150316063639|0
   
8. 13400041414|18870680194|20150316060912|20150316061428|0
   
9. 13400041414|14762010034|20150105110754|20150115104932|9
   
10. 13400041414|15152494334|20141230100609|20141230101153|0
    
11. 13400643973|13400644513|20150515154622|20150515155231|0
    
12. 13400644913|13489937792|20150519111937|20150609144721|21

复制代码

yestreenstars

回复 6# haooooaaa

这结果明显是不对的……

jason680

回复 1# 毛线浅爱

>>想将该文件的第四列 的时间 减去第三列的时间  时间差变换成天数 输出到第五列中...

What You Think Is What You Code(WYTIWYC)

$ awk 'function diffday(s,e){return(int((sec(e)-sec(s))/86400))}function sec(str){gsub(/../,"& ",str);sub(/ /,"",str);return(mktime(str))}BEGIN{FS=OFS="|"}{$5=diffday($3,$4)}1' FILE
13400041414|18702652237|20150302131949|20150302132312|0
13400041414|15052124614|20150107111304|20150302131709|54
13400041414|18279684920|20150302133159|20150313092141|10
13400041414|14779568524|20150316062001|20150316063117|0
13400041414|15103434017|20150119152514|20150313092146|52
13400041414|18479343074|20150316061904|20150316062042|0
13400041414|13405761414|20150316063544|20150316063639|0
13400041414|18870680194|20150316060912|20150316061428|0
13400041414|14762010034|20150105110754|20150115104932|9
13400041414|15152494334|20141230100609|20141230101153|0
13400643973|13400644513|20150515154622|20150515155231|0
13400644913|13489937792|20150519111937|20150609144721|21

Note: https://www.gnu.org/software/gawk/manual/gawk.html#Time-Functions
mktime(datespec)
Turn datespec into a timestamp in the same formas is returned by systime().  It is similar to the function of thesame name in ISO C.  The argument, datespec, is a string of the form"YYYY MM DD HH MM SS [DST]".The string consists of six or seven numbers representing, respectively,the full year including century, the month from 1 to 12, the day of the monthfrom 1 to 31, the hour of the day from 0 to 23, the minute from 0 to59, the second from 0 to 60,53and an optional daylight-savings flag.

   

haooooaaa

回复 8# yestreenstars


    谢谢, 没太仔细看.

1. $ awk -F "|" '{m=$0;for(i=3;i<5;i++){gsub(/[0-9][0-9]/,"& ",$i);t[i]=mktime(gensub(" ","",1,$i))}printf("%s|%s\n",m,int((t[4]-t[3])/86400))}' 2.txt
   
2. 13400041414|18702652237|20150302131949|20150302132312|0
   
3. 13400041414|15052124614|20150107111304|20150302131709|54
   
4. 13400041414|18279684920|20150302133159|20150313092141|10
   
5. 13400041414|14779568524|20150316062001|20150316063117|0
   
6. 13400041414|15103434017|20150119152514|20150313092146|52
   
7. 13400041414|18479343074|20150316061904|20150316062042|0
   
8. 13400041414|13405761414|20150316063544|20150316063639|0
   
9. 13400041414|18870680194|20150316060912|20150316061428|0
   
10. 13400041414|14762010034|20150105110754|20150115104932|9
    
11. 13400041414|15152494334|20141230100609|20141230101153|0
    
12. 13400643973|13400644513|20150515154622|20150515155231|0
    
13. 13400644913|13489937792|20150519111937|20150609144721|21
    

复制代码