新手求救awk 时间转换问题，多谢兄弟们

新手刚来

日志原句      111.160.21.251 - - 2012-11-05 01:01:03 "GET /taskmanager.php?_=1352104610027 HTTP/1.1" 200 39 "www.88.com" "Mozilla/5.0 (Windows NT 5.1; rv:16.0) Gecko/20100101 Fire fox/16.0" 0 51130


操作#more 3.log |sed 's/"//g'|awk '{print $1","$4" "$5","$7","$11}'

结果#111.160.21.251,2012-11-05 01:01:03,/taskmanager.php?_=1352104610027,www.88.com

其中想把2012-11-05 01:01:03  替换成unix时间   

#date +%s -d "2012-11-05 01:01:03"
#1352048463


怎样写成一句，直接出来这样的结果

111.160.21.251,1352048463,/taskmanager.php?_=1352104610027,www.88.com最终想要的结果

多谢兄弟们

新手刚来

知道的兄弟帮我解决下吧，多谢了啊

jason680

回复 1# 新手刚来

how about this one

$ echo '111.160.21.251 - - 2012-11-05 01:01:03 "GET /taskmanager.php?_=1352104610027 HTTP/1.1" 200 39 "www.88.com" "Mozilla/5.0 (Windows NT 5.1; rv:16.0) Gecko/20100101 Fire fox/16.0" 0 51130' | awk -F'[ "]+' -vOFS=',' '{cmd="date +%s -d \""$4" "$5"\"";cmd | getline t; print $1,t,$7,$11}'
111.160.21.251,1352048463,/taskmanager.php?_=1352104610027,www.88.com

   

greysky-zfj

回复 1# 新手刚来

1. awk '{print $4,$5}' 3.log|xargs -i date +%s -d "{}"

复制代码

waker

如果用gawk,可以试试mktime()

greysky-zfj

1. 看错了

复制代码

新手刚来

jason680 发表于 2012-11-06 12:19
回复 1# 新手刚来

how about this one

谢谢兄弟，完美解决了

新手刚来

greysky-zfj 发表于 2012-11-06 12:20
回复 1# 新手刚来

多谢兄弟，能提出时间段

ljwd1000

1. awk 'BEGIN{FS="[ \"]+";OFS=","}{x=$4" "$5;gsub(/-|:/," ",x);print $1,mktime(x),$7,$11}' file

复制代码

dn833

1. awk -F '[ :"]+' '{gsub(/-/," ",$4);print $1,mktime($4" "$5" "$6" "$7),$9,$13}'

复制代码