Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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|
hello,
and what is your question? 🙂
Hello,
Could you please elaborate your case with an example with input and expected output values?
Best regards
Sabrina
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