以下のリクエストlogがある場合に、CSVファイルへタイムスタンプと各値を抽出したいと考えております。
ご教授頂けないでしょうか。
以下ログの内容、こちらのログは同じ形で何行もございます。
===
2018-10-18T13:44:02.852 f439b318722a aaaaaa000 ono 4baaca51537321966e69 INFO: +++++++++++++++++++++++++++++++++++++++++++++++++++ rrrrrrrrrrrrrrr
2018-10-18T13:44:02.866 f439b318722a aaaaaa000 ono 4baaca51537321966e69 INFO: /aaaaaa000/jsonp/rrrrrrrrrrrrrrr?merch=ono&spec=sp611&num=10&cookie=ono
2018-10-18T13:44:02.866 f439b318722a aaaaaa000 ono 4baaca51537321966e69 INFO: priors: []
2018-10-18T13:44:02.885 f439b318722a aaaaaa000 ono 4baaca51537321966e69 INFO: rrrrrrrrrrrrrrr type: bo
2018-10-18T13:44:02.885 f439b318722a aaaaaa000 ono 4baaca51537321966e69 INFO: num=10 rcmds=10 backfill=10
2018-10-18T13:44:02.886 f439b318722a aaaaaa000 ono 4baaca51537321966e69 INFO: rcmds: ['85100', '54681', '102617', '32187', '107466', '67792', '35001', '104812', '98296', '77981']
2018-10-18T13:44:02.886 f439b318722a aaaaaa000 ono 4baaca51537321966e69 INFO: redirect: redirect.jsp?merch=ono&spec=sp611&num=10&rqid=277818186&prod=85100&prod=54681&prod=102617&prod=32187&prod=107466&prod=67792&prod=35001&prod=104812&prod=98296&prod=77981
2018-10-18T13:44:02.886 f439b318722a aaaaaa000 ono 4baaca51537321966e69 INFO: profile updates: 1, blackboard updates: 0
2018-10-18T13:44:02.886 f439b318722a aaaaaa000 ono 4baaca51537321966e69 INFO: elapsed: 0.033
2018-10-18T13:44:02.886 f439b318722a aaaaaa000 ono 4baaca51537321966e69 INFO: --------------------------------------------------- rrrrrrrrrrrrrrr
上記を以下のような形でCSVへ落とし込みたいと考えております。
march | spec | num | cookie | priors | rrrrrrrrrrrrrrr | type | rrrrrrrrrrrrrrr | flavor | rcmd | backfill | rcmds | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2018-10-18T13:44:02.866 | ono | sp611 | 10 | ono | ||||||||
2018-10-18T13:44:02.866 | [] | |||||||||||
2018-10-18T13:44:02.885 | bo | |||||||||||
2018-10-18T13:44:02.885 | bb | |||||||||||
2018-10-18T13:44:02.885 | 10 | 10 | ||||||||||
2018-10-18T13:44:02.886 | ['85100', '54681', '102617', '32187', '107466', '67792', '35001', '104812', '98296', '77981'] |
回答1件
あなたの回答
tips
プレビュー