Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Get lines which has pattern1, pattern2 and pattern3 in it

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Get lines which has pattern1, pattern2 and pattern3 in it
# 1  
Old 08-11-2015
Get lines which has pattern1, pattern2 and pattern3 in it
Version: RHEL 6.5

In the below text file, I want to find the lines which has the string JOHN , KATE and STEVE in it.
The logic is to grep with an AND condition ie. get all lines with JOHN AND KATE AND STEVE
Code:
$ cat sometext.txt
PHILIP worked in HR
JOHN along with KATE fixed several IT issues. But, Steve got all the credit
JOHN worked in IT Department
KATE worked in the IT Department
STEVE worked in IT department

expected output:
JOHN along with KATE fixed several IT issues. But, Steve got all the credit

The following will work. But I need to grep multiple times. Is there another quick way using grep,egrep, awk, sed , ...etc ?
Code:
$ cat sometext.txt | grep -i JOHN | grep -i KATE| grep -i STEVE
JOHN along with KATE fixed several IT issues. But, Steve got all the credit

# 2  
Old 08-11-2015
Hello John K,

Following may help you in same.
Code:
 awk '{match($0,/JOHN.*KATE.*Steve.*/);VAL=substr($0,RSTART,RLENGTH);if(VAL){print VAL}}'  Input_file

Output will be as follows.
Code:
 JOHN along with KATE fixed several IT issues. But, Steve got all the credit

Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
John K
# 3  
Old 08-11-2015
Might not be the most elegant solution:
Code:
awk '{T=toupper($0)} T ~ /JOHN/ && T ~ /KATE/ && T ~ /STEVE/ ' file
JOHN along with KATE fixed several IT issues. But, Steve got all the credit

This User Gave Thanks to RudiC For This Post:
John K
# 4  
Old 08-11-2015
If you want them in the same order (as in your example):
Code:
grep -i 'JOHN.*KATE.*STEVE' sometext.txt

If you want them in any order:
Code:
awk '/[Jj][Oo][Hh][Nn]/ && /[Kk][Aa][Tt][Ee]/ && /[Ss][Tt][Ee][Vv][Ee]/' sometext.txt

Note that with your code (and either of the above) "skate" will be accepted as a match for KATE and "Stevenson" will be accepted as a match for STEVE. So, if you don't want:
Code:
Last winter, Johnny skated on the Stevens lake reservoir.

to be selected, you need to clarify your requirements.
This User Gave Thanks to Don Cragun For This Post:
John K
# 5  
Old 08-11-2015
If pattern order does not matter.
Code:
perl -nle '/JOHN/i and /KATE/i and /STEVE/i and print' sometext.txt

Using pattern order.
Code:
perl -nle '/JOHN.*KATE.*STEVE/i and print' sometext.txt

/i is for case insensitive, remove if case matters.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Match pattern1 in file, match pattern2, substitute value1 in line

not getting anywhere with this an xml file contains multiple clients set up with same tags, different values. I need to parse the file for client foo, and change the value of tag "64bit" from false to true. cat clients.xml <Client type"FIX"> <ClientName>foo</ClientName>... (3 Replies)
Discussion started by: jack.bauer
3 Replies

2. Shell Programming and Scripting

Delete Lines : after pattern1 and between pattern2 and pattern3 using awk/sed/perl

Hi I need to delete lines from a file which are after pattern1 and between pattern 2 and patter3, as below: aaaaaaaa bbbbbbbb pattern1 cdededed ddededed pattern2 fefefefe <-----Delete this line efefefef <-----Delete this line pattern3 adsffdsd huaserew Please can you suggest... (6 Replies)
Discussion started by: vk2012
6 Replies

3. Shell Programming and Scripting

Append text to line if begins with pattern1 AND does not end with pattern2

Hello, I'm looking for sed solution to change ... <li>keyword</li> <li>keyword <li>keyword</li> <li>keyword <li>keyword</li> ... to ... <li>keyword</li> <li>keyword</li> <li>keyword</li> <li>keyword</li> <li>keyword</li> ... I.e., if lines beginning with <li> do not end with... (3 Replies)
Discussion started by: pioavi
3 Replies

4. Shell Programming and Scripting

delete part of file from pattern1 to pattern2

Hi all! How can I delete all the text starting from <string1> to <string2> in all the .txt files of the folder "FOLDER" ? Thanks a lot! mjomba ... </s> <s> <w></w> </s> <s> ... to get: (1 Reply)
Discussion started by: mjomba
1 Replies

5. Shell Programming and Scripting

Search file for pattern2 starting from occurence of pattern1

Hi folks, I have a file which contains several occurences of 2 different patterns. I need to find out the line of first occurence of pattern2 starting after the position of first occurence of pattern1. example file: aaaa pattern2 bbbb pattern1 ccc pattern2 ddd pattern1 eee pattern2... (9 Replies)
Discussion started by: sameucho
9 Replies

6. Shell Programming and Scripting

How to remove a specific line matching pattern1 and pattern2 ?

Hi, I have a file like below: . . . . Jack is going home Jack is going to school Jack is sleeping Jack is eating dinner John is going home John is eating breakfast . . . The specific line is: Jack is going home (2 Replies)
Discussion started by: salih81
2 Replies

7. Shell Programming and Scripting

Sed Help.To Search Between Pattern1 And Pattern2 Containing Certain Text

Hi, Here is a sample of my Test File $ cat TestFile1 Prompt Table DQZ_ALTER_SCHEMA_ID; ALTER TABLE DQZ.DQZ_ALTER_SCHEMA_ID MONITORING; ALTER TABLE DQZ.DQZ_ALTER_SCHEMA_ID STORAGE ( NEXT 3464K ); Prompt Table DQZ_ALTER_SCHEMA_ID; ALTER TABLE DQZ.DQZ_ALTER_SCHEMA_ID MOVE LOB... (16 Replies)
Discussion started by: rajan_san
16 Replies

8. Shell Programming and Scripting

SED Exclude Matches Between Pattern1 And Pattern2 Containing Pattern3 Print The Rest

Hi, From the sample file below Conditions 1) Pattern Range must start with "ALTER TABLE" 2) Pattern Range ends when it finds ";" 3) Between this range i want to select all the patterns that contain pattern " MOVE " Note : I would like to exclude the above pattern matches and print... (1 Reply)
Discussion started by: rajan_san
1 Replies

9. Shell Programming and Scripting

grep all lines from PATTERN1 to PATTERN2

Hi! From a file like this one : hello ... PATTERN1 ... lines between patterns .. PATTERN2 ... I would like to extract only the lines between patterns, probably with awk I think? Thanks a lot for your help, Tipi (5 Replies)
Discussion started by: tipi
5 Replies

10. Shell Programming and Scripting

how to delete text from line starting pattern1 up to line before pattern2?

My data is xml'ish (here is an excerpt) :- <bag name="mybag1" version="1.0"/> <contents id="coins"/> <bag name="mybag2" version="1.1"/> <contents id="clothes"/> <contents id="shoes"/> <bag name="mybag3" version="1.6"/> I want to delete line containing mybag2 and its subsequent... (5 Replies)
Discussion started by: repudi8or
5 Replies
Login or Register to Ask a Question