in reply to insert null in missing rows
Hello ukhare,
What have you tried so far, and how has it fallen short of your requirements?
I think the basic algorithm is quite straightforward:
The only tricky part is incrementing the timestamp. Here is one approach:
sub inc { my ($next) = @_; my ($hours, $mins, $secs) = split /:/, $next; $mins += 10; if ($mins >= 60) { ++$hours; $mins -= 60; } return sprintf '%02d:%02d:%02d', $hours, $mins, $secs; }
which you would call like this:
$next = inc($next);
Update: Changed $mins = 0; to $mins -= 60; to allow for the possibility that minutes are not multiples of 10.
Hope that helps,
| Athanasius <°(((>< contra mundum | Iustus alius egestas vitae, eros Piratica, |
|
|---|