截取时间段和转化为时间戳

songyc_2015

请教大神一个问题：
输入：
Apr 07, 2015 6:13:30 PM org.apache.coyote.http11.AbstractHttp11Processor endRequest

输出：
Apr 07, 2015 6:13:30 PM

要求：
用awk怎么截取到行首到PM或AM为止的时间，并将该时间段转化为时间戳1428401610，不能在awk里调用date命令

jason680

回复 1# songyc_2015

mktime(datespec)

    Turn datespec into a timestamp in the same form as is returned by systime(). It is similar to the function of the same 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 month from 1 to 31, the hour of the day from 0 to 23, the minute from 0 to 59, the second from 0 to 60,54 and an optional daylight-savings flag.

    The values of these numbers need not be within the ranges specified; for example, an hour of -1 means 1 hour before midnight. The origin-zero Gregorian calendar is assumed, with year 0 preceding year 1 and year -1 preceding year 0. The time is assumed to be in the local timezone. If the daylight-savings flag is positive, the time is assumed to be daylight savings time; if zero, the time is assumed to be standard time; and if negative (the default), mktime() attempts to determine whether daylight savings time is in effect for the specified time.

    If datespec does not contain enough elements or if the resulting time is out of range, mktime() returns -1.
   

dn833

1. awk -F "[ ,:]+" '{if($1~/Apr/)$1="04";if($1~/Jan/)$1="01";if($4~/^.$/)$4="0"$4;print strftime("%s",mktime($3" "$1" "$2" "$4" "$5" "$6))}'

复制代码

例子里懒得写那么多$1的月份匹配了，反正都一样LZ自己补齐就是了

reyleon

1. awk 'BEGIN{
   
2.     a["Jan"]=01
   
3.     a["Feb"]=02
   
4.     a["Mar"]=03
   
5.     a["Apr"]=04
   
6.     a["May"]=05
   
7.     a["Jun"]=06
   
8.     a["Jul"]=07
   
9.     a["Aug"]=08
   
10.     a["Sep"]=09
    
11.     a["Oct"]=10
    
12.     a["Nov"]=11
    
13.     a["Dec"]=12
    
14.     FS="[ :,]+"
    
15. }{
    
16.     if($7=="PM") $4=$4+12
    
17.     print mktime($3" "a[$1]" "$2" "$4" "$5" "$6)
    
18. }
    
19. ' file

复制代码

我是一隻羊

1. echo "Apr 07, 2015 6:13:30 PM org.apache.coyote.http11.AbstractHttp11Processor endRequest"|awk -F'[,: ]' -vT="Jan|Feb|Mar|Apr|May|June|July|Aug|Sep|Oct|Nov|Dec" 'function m (x,y) {for(i=0;i<x;i++)y="0"y;return y}BEGIN{split(T,a,"|");for(;j++<12;){b[a[j]]=m(1-(j/10),j)}}{$5=$8=="AM"?$5:($5+12);c=$4" "b[$1]" "$2" "$5" "$6" "$7;print mktime(c)}' inputfile

复制代码

songyc_2015

感谢楼上各位大神指导