Need to filter the result set within 2 time frame


 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Need to filter the result set within 2 time frame
# 1  
Old 05-25-2018
Question Need to filter the result set within 2 time frame

my sample file is like this
Code:
$cat onefile
05/21/18 13:10:07        ABRT US1CPDAY Status 1
05/21/18 21:18:54        ABRT DailyBackup_VFFPRDAPENTL01 Status 6
05/21/18 21:26:24        ABRT DailyBackup_VFFPRDAPENTL02 Status 6
05/21/18 21:57:36        ABRT DailyBackup_vm-ea1ffpreng01 Status 6
05/22/18 13:11:56        ABRT US1CPDAY Status 1
05/22/18 22:05:00        ABRT US1EXNITE Status 1
05/23/18 13:11:24        ABRT US1CPDAY Status 1
05/24/18 13:12:29        ABRT US1CPDAY Status 1
05/24/18 23:23:49        ABRT DailyBackup_IAM-FF-SMTP Status 156

i want to grep the lines between 05/22/18 to 05/23/18

I tried with sed
Code:
sed -n '/$first/,/$last/p' onefile

but it does not work.

I tried with grep -e
Code:
grep -e "05/22/18" -e "05/23/18"

it too did not work complaining about illegal option -e


PLease help !!
# 2  
Old 05-25-2018
how about - assuming the is sorted temporally and the to/from recods are present in the file...
Code:
awk -v f='05/21/18' -v t='05/23/18' '$1==f,$1==t' myFile

This User Gave Thanks to vgersh99 For This Post:
# 3  
Old 05-25-2018
sorry, but it did not work .
it says
Code:
awk: syntax error near line 1
awk: bailing out near line 1

# 4  
Old 05-25-2018
Quote:
Originally Posted by gotamp
my sample file is like this
Code:
$cat onefile
05/21/18 13:10:07        ABRT US1CPDAY Status 1
05/21/18 21:18:54        ABRT DailyBackup_VFFPRDAPENTL01 Status 6
05/21/18 21:26:24        ABRT DailyBackup_VFFPRDAPENTL02 Status 6
05/21/18 21:57:36        ABRT DailyBackup_vm-ea1ffpreng01 Status 6
05/22/18 13:11:56        ABRT US1CPDAY Status 1
05/22/18 22:05:00        ABRT US1EXNITE Status 1
05/23/18 13:11:24        ABRT US1CPDAY Status 1
05/24/18 13:12:29        ABRT US1CPDAY Status 1
05/24/18 23:23:49        ABRT DailyBackup_IAM-FF-SMTP Status 156

i want to grep the lines between 05/22/18 to 05/23/18

I tried with sed
Code:
sed -n '/$first/,/$last/p' onefile

but it does not work.

I tried with grep -e
Code:
grep -e "05/22/18" -e "05/23/18"

it too did not work complaining about illegal option -e


PLease help !!
Your statement describing what output you want is ambiguous. The only line between the first occurrence of 05/22/18 and 05/23/18 is the single line:
Code:
05/22/18 22:05:00        ABRT US1EXNITE Status 1

Is that what you want?

Saying that you tried something "but it does not work" does not give us much help in trying to guess what did not work. Did it produce diagnostic messages? Did it give no output? Did it give the wrong output?

What shell and operating system are you using? The command:
Code:
grep -e "05/22/18" -e "05/23/18"

should not complain about an invalid -e option. It should just wait for you to type in data to be processed and print out any lines that contain either of those strings (but, of course, that does not meet any requirements about finding lines between anything).
# 5  
Old 05-25-2018
Quote:
Originally Posted by gotamp
sorry, but it did not work .
it says
Code:
awk: syntax error near line 1
awk: bailing out near line 1

if on Solaris, use nawk...
# 6  
Old 05-25-2018
The shell doesn't expand variables if enclosed in single quotes. Try double quotes:



Code:
sed -n "/$first/,/$last/p" onefile

# 7  
Old 05-25-2018
Quote:
Originally Posted by RudiC
The shell doesn't expand variables if enclosed in single quotes. Try double quotes:



Code:
sed -n "/$first/,/$last/p" onefile

Since the user's $first and $last both expand to strings containing slash (/) characters, double quotes won't work in this case either unless the slashes in the variables are escaped:
Code:
first='05\/22\/18'
last='05\/23\/18'

before invoking sed. And, if that is done, that sed command will print lines from the 1st one matching $first through the 1st one matching $last; it won't print the lines between the patterns, it will also print the first line match each of those patterns.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help with filter result (scientific notation) by using awk

Input file: data1 0.05 data2 1e-14 data1 1e-330 data2 1e-14 data5 2e-60 data5 2e-150 data1 4e-9 Desired output: data2 1e-14 data1 1e-330 data2 1e-14 data5 2e-60 data5 2e-150 I would like to filter out those result that column 2 is less than 1e-10. Command try: (1 Reply)
Discussion started by: cpp_beginner
1 Replies

2. Shell Programming and Scripting

Help on script to capture info on log file for a particular time frame

Hi I have a system running uname -a Linux cmovel-db01 2.6.32-38-server #83-Ubuntu SMP Wed Jan 4 11:26:59 UTC 2012 x86_64 GNU/Linux I would like to capture the contents of /var/log/syslog from 11:00AM to 11:30AM and sent to this info via email. I was thinking in set a cron entry at that... (2 Replies)
Discussion started by: fretagi
2 Replies

3. UNIX for Dummies Questions & Answers

UNIX Account getting Locked Everyday between same Time Frame

I am facing an Issue with a particular Unix Account ( ie a particular Userid) getting LOCKED everyday between 7:30am and 8:00am. The Password associated with this particular Account has been setup such that it should never Expire at all but it does LOCK the Account after more than 3 failed... (5 Replies)
Discussion started by: pchegoor
5 Replies

4. Shell Programming and Scripting

Help with filter result that fulfill criteria

Input file: ##fileformat=tab ##reference=file:input.txt #Line Position Score Input_185827_2127 1071 67 Input_18213_21 1021 100 Input_9012_214 200 150 Input_935_217 124 70 Output file: ##fileformat=tab ##reference=file:input.txt #Line Position Score Input_18213_21 1021... (2 Replies)
Discussion started by: perl_beginner
2 Replies

5. Shell Programming and Scripting

awk : collecting all data between two time frame

Hi Experts , I need your help to collect the complete data between two time frame from the log files, when I try awk it's collecting the data only which is printed with time stamp for example, awk works well from "16:00 to 17:30" but its not collecting <line*> "from 17:30 to 18:00" ... (8 Replies)
Discussion started by: zenkarthi
8 Replies

6. Shell Programming and Scripting

awk : Search for text between two time frame (12 hours)

I have created the script to grep the errors from weblogic logs files and redirecting output to file.txt ...From file.txt I'm using awk command to collect the past 20 mins output...The script running from cron every 15 mins... The script working well... Now the challenges, I'm trying to use... (27 Replies)
Discussion started by: zenkarthi
27 Replies

7. Shell Programming and Scripting

Search for text between two time frame using sed

I have log files with time stamps. I want to search for text between two time stamp using sed even if the first tme stamp or the last time stamp are not present. For e.g. if i search between 9:30 and 9:40 then it should return text even if 9:30 or 9:40 is not there but between 9:30 and 9:40 is... (8 Replies)
Discussion started by: Azher
8 Replies

8. Shell Programming and Scripting

Shell Script to delete files within a particular time frame under multiple sub folders

Greetings! I'm looking for starting information for a shell script. Here's my scenario: I have multiple folders(100) for example: /www/test/applications/app1/logs /www/test/applications/app2/logs Within these folders there are log files files that need to be deleted after a month. ... (3 Replies)
Discussion started by: whysolucky
3 Replies

9. Shell Programming and Scripting

Filter the column and print the result based on condition

Hi all This is my output of the some SQL Query TABLESPACE_NAME FILE_NAME TOTALSPACE FREESPACE USEDSPACE Free ------------------------- ------------------------------------------------------- ---------- --------- ---------... (2 Replies)
Discussion started by: jhon
2 Replies

10. Shell Programming and Scripting

search string during a specific time frame

Can someone please help me with searching a string during a specific time frame. Below is the format of the time from my log file. "GET /AAM2009_wherewereheaded.wmv HTTP/1.1" 200 52307085 The search string I need is "AAM2009_wherewereheaded.wmv" I need to search the number of... (1 Reply)
Discussion started by: tadi18
1 Replies
Login or Register to Ask a Question