How to search a text in file and retrieve required lines following it with UNIX command?

Login or Register to Ask a Question and Join Our Community

How to search a text in file and retrieve required lines following it with UNIX command?

Tags

awk, find, grep, unix & linux - unix commands

Login to Discuss or Reply to this Discussion in Our Community

Top Forums UNIX for Beginners Questions & Answers How to search a text in file and retrieve required lines following it with UNIX command?

01-25-2018

Registered User

3, 0

Join Date: Jan 2018

Last Activity: 16 April 2018, 6:49 AM EDT

Posts: 3

Thanks Given: 2

Thanked 0 Times in 0 Posts

How to search a text in file and retrieve required lines following it with UNIX command?

I have requirement to search for a text in the file and retrieve required lines that is user defined with unix command.

Eg:

Find the text UNIX in the below file and need to return Test 8 & Test 9

Code:

Test 1
Test 2
Test 3
Test 4
UNIX
Test 5
Test 6
Test 7
Test 8
Test 9

Result can be:

Code:

Test 8
Test 9

Please suggest an answer with examples.

Thanks in advance

Moderator's Comments:

Mod Comment

Please use CODE tags as required by forum rules!

Last edited by RudiC; 01-25-2018 at 04:35 AM.. Reason: Added CODE tags.

Arunkumarsak4

View Public Profile for Arunkumarsak4

Find all posts by Arunkumarsak4

01-25-2018

Registered User

15,129, 5,008

Join Date: Jul 2012

Last Activity: 4 May 2020, 4:31 PM EDT

Location: Aachen, Germany

Posts: 15,129

Thanks Given: 735

Thanked 5,008 Times in 4,483 Posts

Welcome to the forum.

Any attempts / ideas / thoughts from your side? Please demonstrate why and by which logic the two lines should be selected once the "UNIX" test was found..

RudiC

View Public Profile for RudiC

Find all posts by RudiC

01-25-2018

Registered User

3, 0

Join Date: Jan 2018

Last Activity: 16 April 2018, 6:49 AM EDT

Posts: 3

Thanks Given: 2

Thanked 0 Times in 0 Posts

I came across below UNIX command, this will return matching text plus the line following it.

Code:

sed -n '/UNIX/,+1p' file.txt >newfile.txt

In the above mentioned example it should return below

Code:

UNIX
Test 5

But this command is not working for me.

The logic I am looking for is to match a file pattern and return the line after the match which is specified by me. (i.e I need to choose which line to return after the text match)

I need some working Unix command for this requirement.

Thanks!!

Last edited by Scott; 01-25-2018 at 05:30 AM.. Reason: Code tags

Arunkumarsak4

View Public Profile for Arunkumarsak4

Find all posts by Arunkumarsak4

01-25-2018

Administrator Emeritus

9,179, 1,331

Join Date: Jun 2009

Last Activity: 26 February 2019, 5:57 PM EST

Posts: 9,179

Thanks Given: 430

Thanked 1,331 Times in 1,120 Posts

What error / output do you get?

If you're using Linux, or have access to GNU grep, so can also do this with:

Code:

$ grep -A1 UNIX file
UNIX
Test 5

or with something like:

Code:

$ sed -n '/UNIX/{N;p;}' file
UNIX
Test 5

This User Gave Thanks to Scott For This Post:

Scott

View Public Profile for Scott

Find all posts by Scott

01-25-2018

Registered User

15,129, 5,008

Join Date: Jul 2012

Last Activity: 4 May 2020, 4:31 PM EDT

Location: Aachen, Germany

Posts: 15,129

Thanks Given: 735

Thanked 5,008 Times in 4,483 Posts

And how would you supply the info "after the match which is specified by me". Please give the entire picture, don't have people in here worm it out of you bit by bit.

RudiC

View Public Profile for RudiC

Find all posts by RudiC

01-25-2018

Administrator Emeritus

9,179, 1,331

Join Date: Jun 2009

Last Activity: 26 February 2019, 5:57 PM EST

Posts: 9,179

Thanks Given: 430

Thanked 1,331 Times in 1,120 Posts

Hmm. I seem to have missed the first post (was referring to post #3).

Scott

View Public Profile for Scott

Find all posts by Scott

01-25-2018

Registered User

12,315, 4,560

Join Date: Jul 2012

Last Activity: 22 November 2019, 4:29 PM EST

Location: San Jose, CA, USA

Posts: 12,315

Thanks Given: 952

Thanked 4,560 Times in 3,818 Posts

I'm sure some of our sed experts could do this with sed, but I find ed with a here-document much easier to deal with when using offsets from a line that matches a pattern. With a POSIX conforming shell (or any shell that uses Bourne shell syntax and supports arithmetic expansions) the following script should do what you want with either ed or ex:

Code:

BRE=UNIX	# Basic Regular Expression to search for.
after=4		# Lines after match where first line to be printed will be found
count=2		# Number of lines to print.
file=file	# Pathname of file to be searched.

ed -s "$file" <<EOF
/$BRE/+$after;.+$((count - 1))p
q
EOF

This User Gave Thanks to Don Cragun For This Post:

Don Cragun

View Public Profile for Don Cragun

Find all posts by Don Cragun

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Homework & Coursework Questions

awk command to retrieve record 23 and 89 from UNIX file

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: I am looking for awk command to retrieve only the record number 23 and record number 89 from a unix file?...

2. UNIX for Beginners Questions & Answers

awk command to retrieve record 23 and 89 from UNIX file

Hi Everyone, I am looking for awk command to retrieve only the record number 23 and record number 89 from a unix file? Please let me know what is the awk command for this? Regards Rakesh

3. Shell Programming and Scripting

Read in search strings from text file, search for string in second text file and output to CSV

Hi guys, I have a text file named file1.txt that is formatted like this: 001 , ID , 20000 002 , Name , Brandon 003 , Phone_Number , 616-234-1999 004 , SSNumber , 234-23-234 005 , Model , Toyota 007 , Engine ,V8 008 , GPS , OFF and I have file2.txt formatted like this: ...

4. Shell Programming and Scripting

How can i run sql queries from UNIX shell script and retrieve data into text docs of UNIX?

Please share the doc asap as very urgently required.

5. UNIX for Dummies Questions & Answers

Unix search a string in the text file

File name : Sample.txt Actually i would like to read <schema>Oracle<schema> string from input file and return only once database as my output. Please advise me. Moved to appropriate forum.

6. Shell Programming and Scripting

search string in a file and retrieve 10 lines including string line

Hi Guys, I am trying to write a perl script to search a string "Name" in the file "FILE" and also want to create a new file and push the searched string Name line along with 10 lines following the same. can anyone of you please let me know how to go about it ?

7. Shell Programming and Scripting

Getting required fields from a test file in required fromat in unix

My data is something like shown below. date1 date2 aaa bbbb ccccc date3 date4 dddd eeeeeee ffffffffff ggggg hh I want the output like this date1date2 aaa eeeeee I serached in the forum but didn't find the exact matching solution. Please help.

8. Shell Programming and Scripting

Getting required fields from a text file in UNIX

My data is something like as shown below. Out of this i want the details of alarms (ex: 1947147711,1947147081......) and the fields( ex :sw=tacmwafabb9:shelf=1:slot=5-2:pport=2) Once i have these details separated, i want the count of these excluding the duplicates. What is the best possible way...

9. Shell Programming and Scripting

how to retrieve required specific info from the file

Hi I have a file which consists of a number in the square brackets, followed by the blank line, then several lines which describe this number. This pattern is repeated several thousands time. The number in the brackets and the decription of it is unique. For example: ASRVSERV=1241GD;...

10. Shell Programming and Scripting

search and retrieve previous line in file

I've got a file with the following layout: #STMP FSgroup filename /filesysname1 filestatus 2 #STMP FSstatus filename /filesysname1 ratio 30 #STMP FSgroup filename ...

Login or Register to Ask a Question