access-2018-04-25.log
2018 -08 -30 17 :34 :06.104 [vert.x -eventloop-thread-0 ] INFO com .cbx .cpm .logging .CpmLoggerHandlerImpl - 127.0 .0 .1 - - KMT [Thu, 30 Aug 2018 17 :34 :06 GMT] "GET /cpm/fa893fab-c1eb-4a6a-b78e-7a1efd5ade94 HTTP/1.1" 200 6760 "-" "Apache-HttpClient/4.5.2 (Java/1.8.0_181)"
2018 -08 -30 17 :34 :06.371 [vert.x -eventloop-thread-0 ] INFO com .cbx .cpm .logging .CpmLoggerHandlerImpl - 127.0 .0 .1 - - KMT [Thu, 30 Aug 2018 17 :34 :06 GMT] "POST /cpm/history/fa893fab-c1eb-4a6a-b78e-7a1efd5ade94 HTTP/1.1" 200 3593 "-" "Apache-HttpClient/4.5.2 (Java/1.8.0_181)"
command
cat access-2018-04-25.log | awk '($14 !="23:59:59" ) {print $1 "\t" $2 "\t" $15 "\t" ((substr($2 ,4,2)*60 + substr($2 ,7,2))*1000+substr($2 ,10,3) - (substr($15 ,4,2)*60 + substr($15 ,7,2))*1000)/1000 "\t" $4 "\t" substr($17 ,2) "\t" $18 "\t" $20 }'
result
2018 - 08 - 30 17 :34 :06.104 17 :34 :06 0.104 INFO GET /cpm/fa893fab-c1eb - 4 a6a-b78e - 7 a1efd5ade94 200
2018 - 08 - 30 17 :34 :06.371 17 :34 :06 0.371 INFO POST /cpm/history/fa893fab-c1eb - 4 a6a-b78e - 7 a1efd5ade94 200