Hi Monks, This is probably a no brainer for anyone with half a clue about Perl. Unfortunately I have neither clue nor brain this morning.

I have a tab delimted file containing the output from an HTTP proxy with data in the following format:

Date           time      User ID   Source IP  
YYYY-MM-DD    HH:MM:SS     text   123.456.789.123 

Dest.IP          Uri-Stem       Ref.       Bytes
123.456.789.123    URL          NUMBER       NUMBER

[download]
Specifically I need to parse the time portion to pick out any activity between the hours of 08:45:00 and 12:00:00 and then 02:00:00 and 17:00:00.

I just cant seem to get my head around either the RegEx to parse it or the Time function that might make it easier. Can anyone help?

Many Thanks.

DB

Many Thanks to all who answered. I now have a clue, still no brain though :)

DB

In reply to parsing time information from a TAB delimited array, kind of. by dbuk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.