原始数据:
17/Apr/2015:09:29:24 +0800
17/Apr/2015:09:30:26 +0800
17/Apr/2015:09:31:56 +0800
18/Apr/2015:09:34:12 +0800
18/Apr/2015:09:35:23 +0800
19/Apr/2015:09:23:34 +0800
19/Apr/2015:09:22:21 +0800
20/Apr/2015:09:45:22 +0800
期望结果:
2015-04-17 09:29:24 +0800
2015-04-17 09:30:26 +0800
2015-04-17 09:31:56 +0800
2015-04-18 09:34:12 +0800
2015-04-18 09:35:23 +0800
2015-04-19 09:23:34 +0800
2015-04-19 09:22:21 +0800
2015-04-20 09:45:22 +0800
方法一:[root@yu yu]# sed 's#Apr#04#g' yu.txt|awk -F "[/:]+" '{print $3"-"$2"-"$1,$4":"$5":"$6}'
2015-04-17 09:29:24 +0800
2015-04-17 09:30:26 +0800
2015-04-17 09:31:56 +0800
2015-04-18 09:34:12 +0800
2015-04-18 09:35:23 +0800
2015-04-19 09:23:34 +0800
2015-04-19 09:22:21 +0800
2015-04-20 09:45:22 +0800
方法二:[root@yu yu]# sed -r 's#Apr#04#g;s#(.*)\/(.*)\/(2015):(.*)#\3-\2-\1 \4#g' yu.txt
2015-04-17 09:29:24 +0800
2015-04-17 09:30:26 +0800
2015-04-17 09:31:56 +0800
2015-04-18 09:34:12 +0800
2015-04-18 09:35:23 +0800
2015-04-19 09:23:34 +0800
2015-04-19 09:22:21 +0800
2015-04-20 09:45:22 +0800
方法三:[root@yu yu]# awk 'BEGIN{FIELDWIDTHS="2 1 3 1 4 1 14"}{print $5"-04-"$1,$7}' yu.txt
2015-04-17 09:29:24 +0800
2015-04-17 09:30:26 +0800
2015-04-17 09:31:56 +0800
2015-04-18 09:34:12 +0800
2015-04-18 09:35:23 +0800
2015-04-19 09:23:34 +0800
2015-04-19 09:22:21 +0800
2015-04-20 09:45:22 +0800