searching between start and end time


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting searching between start and end time
# 1  
Old 01-29-2009
searching between start and end time

Hello All,

Below mentioned is my log file.

I want to make a script which ask for start time and then end time and then search particular word between those lines.

Like
start time:2
end time: 4
and then search all values starting from cell 84 between this time.

Please Help

Regards,

Code:
01/29/09 02:20:39 #283986
^Y
M 15 OP:ALARM
     CELL 74, CDM 1 CDMA BASEBAND RADIO (CBR) 2
     CELL 74, CDM 1 CDMA BASEBAND RADIO (CBR) 3
     CELL 74, CDM 1 CBR 1 TRANSMIT PORT (TXPORT) 1
     CELL 74, CDM 1 CBR 2 TRANSMIT PORT (TXPORT) 1
     CELL 74, CDM 1 CBR 3 TRANSMIT PORT (TXPORT) 1
     CELL 74, CDM 1 CBR 1 TRANSMIT PORT (TXPORT) 2
     CELL 74, CDM 1 CBR 2 TRANSMIT PORT (TXPORT) 2
     CELL 74, CDM 1 CBR 3 TRANSMIT PORT (TXPORT) 2
     CELL 74, ASMB 1 TRANSMITTER AMP INDETERMINATE 1
     CELL 74, ASMB 1 TRANSMITTER AMP INDETERMINATE 2
     CELL 74, ASMB 1 TRANSMITTER AMP INDETERMINATE 4
     CELL 74, ASMB 1 TRANSMITTER AMP INDETERMINATE 5

01/29/09 03:10:39 #283986
^Y
M 15 OP:ALARM
     CELL 74, CDM 1 CDMA BASEBAND RADIO (CBR) 2
     CELL 74, CDM 1 CDMA BASEBAND RADIO (CBR) 3
     CELL 74, CDM 1 CBR 1 TRANSMIT PORT (TXPORT) 1
     CELL 74, CDM 1 CBR 2 TRANSMIT PORT (TXPORT) 1
     CELL 74, CDM 1 CBR 3 TRANSMIT PORT (TXPORT) 1
     CELL 74, CDM 1 CBR 1 TRANSMIT PORT (TXPORT) 2
     CELL 74, CDM 1 CBR 2 TRANSMIT PORT (TXPORT) 2
     CELL 74, CDM 1 CBR 3 TRANSMIT PORT (TXPORT) 2
     CELL 74, ASMB 1 TRANSMITTER AMP INDETERMINATE 1
     CELL 74, ASMB 1 TRANSMITTER AMP INDETERMINATE 2
     CELL 74, ASMB 1 TRANSMITTER AMP INDETERMINATE 4
     CELL 74, ASMB 1 TRANSMITTER AMP INDETERMINATE 5

01/29/09 04:01:39 #283986
^Y
M 15 OP:ALARM
     CELL 14, CDM 1 CDMA BASEBAND RADIO (CBR) 2
     CELL 24, CDM 1 CDMA BASEBAND RADIO (CBR) 3
     CELL 34, CDM 1 CBR 1 TRANSMIT PORT (TXPORT) 1
     CELL 34, CDM 1 CBR 2 TRANSMIT PORT (TXPORT) 1
     CELL 34, CDM 1 CBR 3 TRANSMIT PORT (TXPORT) 1
     CELL 84, CDM 1 CBR 1 TRANSMIT PORT (TXPORT) 2
     CELL 84, CDM 1 CBR 2 TRANSMIT PORT (TXPORT) 2
     CELL 84, CDM 1 CBR 3 TRANSMIT PORT (TXPORT) 2
     CELL 4, ASMB 1 TRANSMITTER AMP INDETERMINATE 1
     CELL 54, ASMB 1 TRANSMITTER AMP INDETERMINATE 2
     CELL 54, ASMB 1 TRANSMITTER AMP INDETERMINATE 4
     CELL 64, ASMB 1 TRANSMITTER AMP INDETERMINATE 5

01/29/09 05:01:39 #283986
CELL 34, CDM 1 CBR 3 TRANSMIT PORT (TXPORT) 1
     CELL 84, CDM 1 CBR 1 TRANSMIT PORT (TXPORT) 2
     CELL 84, CDM 1 CBR 2 TRANSMIT PORT (TXPORT) 2
     CELL 84, CDM 1 CBR 3 TRANSMIT PORT (TXPORT) 2
     CELL 4, ASMB 1 TRANSMITTER AMP INDETERMINATE 1
     CELL 54, ASMB 1 TRANSMITTER AMP INDETERMINATE 2
     CELL 54, ASMB 1 TRANSMITTER AMP INDETERMINATE 4
     CELL 64, ASMB 1 TRANSMITTER AMP INDETERMINATE 5
01/29/09 06:01:39 #283986

# 2  
Old 01-29-2009
Run the code below from a script with the parameters like this: "start" "end" "search string".

Code:
cat your_log_file | awk "/01\/29\/09 0$1:20:39/,/01\/29\/09 0$2:10:39/{print}" | awk "/$3/{print}"

# 3  
Old 01-30-2009
Hello All ,

I am using the below code to find my desired line between start and end line. Red marked are my start and end time and i want to
find the desired line between them. Can you please check and correct my script because below code is not working with arguments.

Code:
echo "ENTER FIRST:"
read GR
echo "ENTER SECOND:"
read QR
cat /omp/omp-data/logs/OMPROP1/090130.APX  | nawk -v END=$GR START=$QR  "/END/{exit}/START/{print}" | nawk "/CARRIER/{print}"

01/29/09 01:00:59 #493740
^Y
A 00 REPT:CELL 30 CP FAILURE, ANSWERED TERMINATION
     LOST CALL
     DCS 1 TG 998 TM 385 SG 0 ANT 1
     CARRIER 2, CHAN UNAVAIL FS-ECP ID 1, SYS ID 13
     DN 0218351023, MIN 0218351023, IMSI UNAVAIL
     SN X2b5332b6 SCM ea
     ALW CDMA, ASGN CDMA
     CDM 1, CCU 1, CE 93, PP 3, ECP ID 1, SYS ID 13

01/30/09 02:00:00 #493741

But below mentioned line is working:
it starts from the word A and when 01/30/09 comes it stops and prints the line starting from CARRIER.

Code:
cat /omp/omp-data/logs/OMPROP1/090130.APX  | nawk  "/01\/30\/09/{exit}/A/{print}" | nawk "/CARRIER/{print}"


Last edited by wakhan; 01-30-2009 at 04:10 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Programming

DB2 Query to check table counts,start end time

Dear team I am using DB2 and wish to capture the ETL status on daily basis so that i can run the query and share the details in xls format to respective mail ids . Currently i am using below query but this displays table name and counts for latest run. select name ,CARD from... (0 Replies)
Discussion started by: Perlbaby
0 Replies

2. Shell Programming and Scripting

Remove lines between the start string and end string including start and end string Python

Hi, I am trying to remove lines once a string is found till another string is found including the start string and end string. I want to basically grab all the lines starting with color (closing bracket). PS: The line after the closing bracket for color could be anything (currently 'more').... (1 Reply)
Discussion started by: Dabheeruz
1 Replies

3. Shell Programming and Scripting

Getting the Start, End time and duration using date command

Oracle Enterprise Linux We want to track how long a process takes to complete its execution. This is what we want in the schell script Before the process is started , get the time with date, hours and minutes execute the process After the process has ended , get the time with date,... (5 Replies)
Discussion started by: omega3
5 Replies

4. UNIX for Dummies Questions & Answers

Setup a cron job and specified the start and end time

Hi guys, How can I specify the start and end time of a cron job. And my start time and end time are specified by minutes. For example, I want to set up a cron runs every 3 minutes from 18:40 to midnight. How can i do this please? Many thanks Best regards, Clu (4 Replies)
Discussion started by: clu
4 Replies

5. Shell Programming and Scripting

How to calculate time difference between start and end time of a process!

Hello All, I have a problem calculating the time difference between start and end timings...! the timings are given by 24hr format.. Start Date : 08/05/10 12:55 End Date : 08/09/10 06:50 above values are in mm/dd/yy hh:mm format. Now the thing is, 7th(08/07/10) and... (16 Replies)
Discussion started by: smarty86
16 Replies

6. UNIX for Dummies Questions & Answers

script start and end of execution of time

Hi All, Can we get to know the start time and end time of execution of a script? (This script doesn't write any logs.) I mean, is there any built in process logs to track these records? (2 Replies)
Discussion started by: siba.s.nayak
2 Replies

7. Shell Programming and Scripting

How to get data between the start time and end time?

Hi, Can anyone help me how can I get the line that between the start time and end time. file1.txt 15/03/2009 20:45:03 Request: - Data of this line 15/03/2009 20:45:12 Response: - Data of this line 15/03/2009 22:10:40 Request: - Data of this line 15/03/2009 22:10:42 Response: - Data of... (1 Reply)
Discussion started by: tanit
1 Replies

8. Shell Programming and Scripting

Start time/end time and status of crontab job

Is there anyway to get the start time and end time / status of a crontab job which was just completed? Of course, we know the start time of the crontab job since we are scheduling. But I would like to know process start and time recorded somewhere or can be fetched from a command like 'ps'. ... (3 Replies)
Discussion started by: thambi
3 Replies

9. UNIX for Dummies Questions & Answers

Working out end time from start + elapsed

Hi, I'm writing a script and have become stuck trying to define a variable (COMP) by adding an elapsed time (ELAPSE e.g 00:55) to a start time (START e.g 23:50). Can anybody give me a solution as to how I can get a completion time in hh:mm from the variables above? thanks Richard (4 Replies)
Discussion started by: rik1551
4 Replies
Login or Register to Ask a Question