i want to get the connection period for the particular IP from the the logs.

[Anonymous]

Id|Client_IP     |finished|started |
|=-+--------------+--------+-------=|
|1 |49.36.129.39  |10:21:39|        |
|2 |103.60.187.233|        |16:55:56|
|3 |103.60.187.233|18:07:16|        |
|4 |103.60.187.233|        |18:15:59|
|5 |163.53.85.151 |        |20:36:56|
|7 |163.53.85.151 |        |21:28:49|
|8 |163.53.85.151 |21:28:49|        |
|10|163.53.85.151 |        |21:29:26|
|12|47.30.216.132 |        |06:01:08|
|13|47.30.216.132 |07:17:14|        |
|14|47.30.216.132 |        |07:27:19|

[vapukov]

hello,

and what is your question? 🙂

[Anonymous]

Hello,

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

[Anonymous]

Hi,

I am working on logs data and i want to normalize that data , so that i can calculate the connection started and finished time.

My input file is this.

My desired output is