Hi guys,
I need some help to create a script or command
I do not have much experience in shell programming
I have a file with the lines below on 10000 lines:
12.06.09/14:20:13 4 sms/s
12.06.09/14:20:16 4 sms/s
12.06.09/14:20:17 3 sms/s
12.06.09/14:20:18 3 sms/s
12.06.09/14:20:25 5 sms/s
12.06.09/14:20:26 6 sms/s
12.06.09/14:20:29 2 sms/s
12.06.09/14:20:32 8 sms/s
12.06.09/14:20:33 4 sms/s
12.06.09/14:20:34 2 sms/s
12.06.09/14:20:35 3 sms/s
As you can see, I do not have a line for all seconds which make it really difficult to create graph.
So I try to create a line like 12.06.09/14:20:16 0 sms/s for the empty seconds.
For example :
12.06.09/14:20:13 4 sms/s
12.06.09/14:20:14 0
12.06.09/14:20:15 0
12.06.09/14:20:16 4 sms/s
12.06.09/14:20:17 3 sms/s
12.06.09/14:20:18 3 sms/s
12.06.09/14:20:19 0
12.06.09/14:20:20 0
12.06.09/14:20:21 0
12.06.09/14:20:22 0
12.06.09/14:20:23 0
12.06.09/14:20:24 0
12.06.09/14:20:25 5 sms/s
12.06.09/14:20:26 6 sms/s
That sounds easy but I can't get it to work and I feel like I'm not doing it the good way.
Does anybody knows how to make something like this ?
Thanks in advance for your help.
Julien