LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > Programming
User Name
Password
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.

Notices

Reply
 
Search this Thread
Old 04-20-2012, 10:07 AM   #1
Kashif_Bash
LQ Newbie
 
Registered: Apr 2012
Posts: 20

Rep: Reputation: Disabled
Read lines after a specific word.


I have a text file (basically a log file) in which i have couple of occurrence of word "address 5". Now my requirement is that I reach to last occurrence of this word and then output this line and next 20 lines in some temp file for further manipulation.

or from reverse side: go to end of file and get the first occurrence and output that line and next 20 lines in some temp file.

I'm using Cent OS bash..

thanks in advance. and do let me know if my question isn't clear.
 
Click here to see the post LQ members have rated as the most helpful post in this thread.
Old 04-20-2012, 10:13 AM   #2
Nominal Animal
Senior Member
 
Registered: Dec 2010
Location: Finland
Distribution: Xubuntu, CentOS, LFS
Posts: 1,723
Blog Entries: 3

Rep: Reputation: 942Reputation: 942Reputation: 942Reputation: 942Reputation: 942Reputation: 942Reputation: 942Reputation: 942
How about
Code:
grep -A 20 -e 'address 5' input > output
You get a line containing two dashes (--) in output between matches, unless the matches overlap, in which case you get the output from the first match continuously to 20 lines after the last match in that continuous segment.

If you only want the last match, try
Code:
grep -A 20 -e 'address 5' input | tail -n 21 > output
Edited: To include the match itself, you need 21 last lines (the parameter to tail -n).

Last edited by Nominal Animal; 04-20-2012 at 11:11 AM.
 
2 members found this post helpful.
Old 04-20-2012, 10:59 AM   #3
danielbmartin
Senior Member
 
Registered: Apr 2010
Location: Apex, NC, USA
Distribution: Ubuntu
Posts: 1,142

Rep: Reputation: 300Reputation: 300Reputation: 300Reputation: 300
Quote:
Originally Posted by Nominal Animal View Post
If you only want the last match, try
Code:
grep -A 20 -e 'address 5' input | tail -n 20 > output
Nitpick...
OP asked for the last match and the following 20 lines. I tested this and it returned only the following 20 lines.

Daniel B. Martin
 
1 members found this post helpful.
Old 04-20-2012, 11:12 AM   #4
Nominal Animal
Senior Member
 
Registered: Dec 2010
Location: Finland
Distribution: Xubuntu, CentOS, LFS
Posts: 1,723
Blog Entries: 3

Rep: Reputation: 942Reputation: 942Reputation: 942Reputation: 942Reputation: 942Reputation: 942Reputation: 942Reputation: 942
Quote:
Originally Posted by danielbmartin View Post
OP asked for the last match and the following 20 lines. I tested this and it returned only the following 20 lines.
Quite right, thanks for noticing that. The fix is obvious, using tail -n 21 instead. Fixed in the post.
 
1 members found this post helpful.
Old 04-21-2012, 10:49 AM   #5
David the H.
Bash Guru
 
Registered: Jun 2004
Location: Osaka, Japan
Distribution: Debian sid + kde 3.5 & 4.4
Posts: 6,823

Rep: Reputation: 1949Reputation: 1949Reputation: 1949Reputation: 1949Reputation: 1949Reputation: 1949Reputation: 1949Reputation: 1949Reputation: 1949Reputation: 1949Reputation: 1949
Quote:
Originally Posted by Nominal Animal View Post
You get a line containing two dashes (--) in output between matches...

gnu grep now has two options for controlling this. You can change the separator or leave it out entirely.


Code:
grep --no-group-separator -A 20 -e 'address 5' input > output

grep --group-separator='*****' -A 20 -e 'address 5' input > output

No, they're not mentioned in the man page yet, but they are in the info page.
 
Old 04-23-2012, 11:20 AM   #6
Kashif_Bash
LQ Newbie
 
Registered: Apr 2012
Posts: 20

Original Poster
Rep: Reputation: Disabled
Opening this thread again

Last edited by Kashif_Bash; 04-24-2012 at 05:34 PM.
 
Old 04-24-2012, 05:34 PM   #7
Kashif_Bash
LQ Newbie
 
Registered: Apr 2012
Posts: 20

Original Poster
Rep: Reputation: Disabled
I'm sorry to tell you but I've got a bug in following command:

Quote:
grep -A 20 -e 'New USB device found' /var/log/messages | tail -n 16 > usb_detail
Problem is that I'm trying to get that line with "New USB device found" and NEXT 16 lines. ok. but what this script does is that it goes to last occurrence of "New USB device found" and then just output last 16 lines of log file into temp file.

so it means if there are 20 lines after last occurrence of "New USB device found" then I'll get ending 16 lines. and this is not what I'm looking for. I want next 16 lines after "New USB device found".

Hope this time I'm making it more clear.
 
Old 04-24-2012, 05:52 PM   #8
descendant_command
Member
 
Registered: Mar 2012
Posts: 807

Rep: Reputation: 182Reputation: 182
'grep -A 16 ...' & 'tail -n 17'


Last edited by descendant_command; 04-24-2012 at 05:53 PM.
 
Old 04-25-2012, 11:32 PM   #9
David the H.
Bash Guru
 
Registered: Jun 2004
Location: Osaka, Japan
Distribution: Debian sid + kde 3.5 & 4.4
Posts: 6,823

Rep: Reputation: 1949Reputation: 1949Reputation: 1949Reputation: 1949Reputation: 1949Reputation: 1949Reputation: 1949Reputation: 1949Reputation: 1949Reputation: 1949Reputation: 1949
@descendant_command: Just what do you think the command you posted is supposed to do?


@Kashif_Bash: Think about how the commands you are using work. "grep -A20" prints out every occurrence of the matched line, plus the 20 lines following them. Then that output is sent into "tail -n16", which filters out all but the last 16 lines.

What you really want is the first 16 lines of the last 21 lines of the output. So what we need to do is run it through a second filter, head in this case.

Code:
grep -A 20 -e 'New USB device found' /var/log/messages | tail -n 21 | head -n 16 > usb_detail
However, that would still fail you if the matching string happens to be less than 21 lines from the end of the file. I think this will do you better:

Code:
tac /var/log/messages | grep -B16 -m1 'New USB device found' | tac > usb_detail
tac (cat backwards) reverses the output of the file, so you filter from the last line up. then you grep only the first instance (-m1) of the string, and print it and the 16 lines before it (-B), or as many as there actually are. Then you use tac again to put it back in the correct order.

It may be possible to come up with something cleaner using sed or awk. I'll have to think about it a bit.


Edit: Here's a quickly-knocked-out awk expression that appears to do it, although it's a bit cumbersome. Likely grail or someone will come along and embarrass me with a much simpler version.

Code:
awk '/New USB device found/ { t=""; f=1 } ; { if ( f != 0 && f <= 17 ) { t=t"\n"$0 ; f++ } else{ f=0 }} END{ sub(/^\n/,"",t) ; print t }' /var/log/messages > usb_detail
Edit2: Whoops, I had to revise the code. It was printing an unwanted newline before the output. But I'm not sure how to remove it except to use a sub function. I also decided to shorten the variables to one letter, to make it look a bit cleaner (t for "text" and f for "flag").

Last edited by David the H.; 04-26-2012 at 12:04 AM. Reason: as stated
 
Old 04-26-2012, 12:15 AM   #10
descendant_command
Member
 
Registered: Mar 2012
Posts: 807

Rep: Reputation: 182Reputation: 182
@david

It's not a command - it is a hint as to how to adjust the previous command so that it will work as desired.
 
Old 04-26-2012, 04:06 AM   #11
David the H.
Bash Guru
 
Registered: Jun 2004
Location: Osaka, Japan
Distribution: Debian sid + kde 3.5 & 4.4
Posts: 6,823

Rep: Reputation: 1949Reputation: 1949Reputation: 1949Reputation: 1949Reputation: 1949Reputation: 1949Reputation: 1949Reputation: 1949Reputation: 1949Reputation: 1949Reputation: 1949
Ah, I see it now. You really should take time to explain such things more clearly. I had taken the "&" to be part of the suggested change, which of course is not right at all.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
bash shell script read file word by word part 2 justina Programming 7 01-25-2011 01:19 PM
How can i read two files word by word at a time using any loop by shell script? vaibhavs17 Programming 16 03-19-2010 03:48 AM
print second word in 1st line along with 5th word in all the lines after the first bangaram Programming 5 08-31-2009 03:42 AM
substitute few words + change all the lines starting with a specific word + put blank rahmathullakm Programming 6 01-18-2009 11:35 AM
Read specific lines from a text file chobin Programming 8 06-14-2006 11:14 AM


All times are GMT -5. The time now is 09:02 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration