截取時間段和轉(zhuǎn)化為時間戳

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為止的時間，并將該時間段轉(zhuǎn)化為時間戳1428401610，不能在awk里調(diào)用date命令

jason680

回復(fù) 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))}'

復(fù)制代碼

例子里懶得寫那么多$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

復(fù)制代碼

我是一隻羊

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

復(fù)制代碼

songyc_2015

感謝樓上各位大神指導(dǎo)