To grep a file within a time range using PERL

[hassan470]

I work in an investment bank. We have a huge log file which contains FIX messages. I have a problem to grep FIX messages within a time rage (i.e. between 9:30 am to 11 pm, those were sent by CITIBANK for ticker symbol MSFT). I tried different ways but it did not work. Could anyone please help me?

Here is one of the codes in perl:

#!/usr/bin/perl –w
 
$myfile = “/tmp/fixlog.txt”;
open(FH, $myfile) || die “Can not open”;
while<FH>{
    chomp;
print “$_\n” if (m/CITIBANK/ | /MSFT/  | /20071115-09:30:00 ~ 20071115-11:00:00/);
close(FH);

Here is a code in grep:

  grep ‘/CITIBANK/’ | ‘/MSFT/’ | ‘/20071115-09:30:00 ~ 20071115-11:00:00/’ fixlog

[KevinADC]

Your grep code is not perl. How is the data file formatted?

[hassan470]

Your grep code is not perl. How is the data file formatted?

My grep code is unix command line code.

The data file is raw log file. (FIX messages).
Exactly like this:
8=FIX.4.2
9=74
35=A
49=AXESNET
56=ATLAFM
34=1
43=N
97=N
52=20071101-06:01:37
98=0
108=60
10=237
ATLAFM AXESNET 0  _ 8=FIX.4.2
9=73
35=0
49=AXESNET
56=ATLAFM
34=2
43=N
97=N
52=20071101-06:01:37
112=070136
10=195
ATLAFM AXESNET 0  T 8=FIX.4.2
9=62
35=0
49=AXESNET
56=ATLAFM
34=3
43=N
97=N
52=20071101-06:02:38
10=193
ATLAFM

[NexisPerl]

Can you provide the line you want to match so that someone can provide you with the regex you can use

[hassan470]

Can you provide the line you want to match so that someone can provide you with the regex you can use

I need to get the part of the log file within the following time range using regular expression:

(/20071115-09:30:00 ~ 20071115-11:00:00/);