Databases
StackOverflow2013
Postsdbo
POfind biggest interval in list of time stamps ( Perl preferred )
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POfind biggest interval in list of time stamps ( Perl preferred )
    primarykey
    data
    text
    <p>I'd accept any of the interpreted languages Perl, Python, Bash, etc.. but I'd prefer Perl because it is what I am trying to learn. I have a list of timestamps like:</p> <pre><code>17:31:16 17:31:16 17:31:18 17:31:29 </code></pre> <p>I want to find all of the largest intervals (top 5) between any 2 consecutive lines, and return the time stamps and line numbers. Basically this is a log file for a software build and I am trying to determine which steps took the longest. The example I gave was actually already filtered, lines actually look like: [15:57:42]: CC net/sunrpc/xprtsock.o If you can give me a program that parses that format it would be a little easier, and return the line number where the biggest differences in time occurred.</p> <p>This is what I used to isolate the timestamps from the log </p> <pre><code> perl -lane 'print $1 if $_ =~ /^\[(\d+:\d+:\d+)\]:*/' </code></pre> <p>The type of output I would like to achieve is something like:</p> <pre><code> line 574 20:04:54 line 575 20:24:55 Difference 00:20:01 </code></pre> <p>If you don't want to solve the problem, I would be happy to see some pseudocode or get any advice at all. I have spent time and have no useful code to show for it.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USGL2014
    1. USGL2014
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POfind biggest interval in list of time stamps ( Perl preferred )
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. POfind biggest interval in list of time stamps ( Perl preferred )
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POfind biggest interval in list of time stamps ( Perl preferred )
      1. This table or related slice is empty.
      1. VTDownMod
    1. COIt looks like you want us to write some code for you. While many users are willing to produce code for a coder in distress, they usually only help when the poster has already tried to solve the problem on their own. A good way to demonstrate this effort is to include the code you've written so far, example input (if there is any), the expected output, and the output you actually get (console output, stack traces, compiler errors - whatever is applicable). The more detail you provide, the more answers you are likely to receive.
      singulars
      1. POfind biggest interval in list of time stamps ( Perl preferred )
      1. USMartijn Pieters
    2. COHow did you manage to downvote me so quickly? Does the question appear to the forum before I submit it? All I did was make a regex to grab the timestamps so far ` perl -lane 'print $1 if $_ =~ /^\[(\d+:\d+:\d+)\]:*/'` I haven't had any success solving this problem on my own which is why I am asking for help. I am not a developer, and this problem seems too difficult for my limited scripting.
      singulars
      1. POfind biggest interval in list of time stamps ( Perl preferred )
      1. USGL2014
    3. COReally? Offtopic when asking how to approach a programming problem on a programming site? This is a one or two liner in Perl, it's not like I am looking for some elaborate code! This type of strictness is what will drive people from this community and into a more open community like Reddit. StackExchange sites already are developing a poor reputation due to this type of unhelpful behavior.
      singulars
      1. POfind biggest interval in list of time stamps ( Perl preferred )
      1. USGL2014
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload