How to grep more than 2 fields?

Login or Register to Ask a Question and Join Our Community

How to grep more than 2 fields?

Tags

fields, grep, shell scripts

Login to Discuss or Reply to this Discussion in Our Community

Top Forums Shell Programming and Scripting How to grep more than 2 fields?

10-17-2008

Registered User

54, 0

Join Date: Jun 2006

Last Activity: 20 July 2010, 10:52 PM EDT

Posts: 54

Thanks Given: 0

Thanked 0 Times in 0 Posts

How to grep more than 2 fields?

Hi all,

Currently I have this:
ps -eo pid,comm| grep CSORDB1T

But I need to grep LOCAL=NO as well:
ps -eo pid,comm| grep CSORDB1T |grep LOCAL=NO >pdwh_pid

However, there's no output. Plz advise how can we grep CSORDB1T & LOCAL=NO at the same time.

Thanks!

*Jess*

View Public Profile for *Jess*

Find all posts by *Jess*

10-17-2008

Registered User

2,050, 105

Join Date: Jun 2008

Last Activity: 9 June 2020, 12:25 AM EDT

Location: INDIA, Bangalore

Posts: 2,050

Thanks Given: 16

Thanked 105 Times in 102 Posts

use awk
if you want to display when both found use this..

Code:

ps -eo pid,comm|awk '/CSORDB1T/&&/LOCAL=NO/{print}'

otherwise

Code:

ps -eo pid,comm|awk '/CSORDB1T/||/LOCAL=NO/{print}'

vidyadhar85

View Public Profile for vidyadhar85

Find all posts by vidyadhar85

10-17-2008

Registered User

54, 0

Join Date: Jun 2006

Last Activity: 20 July 2010, 10:52 PM EDT

Posts: 54

Thanks Given: 0

Thanked 0 Times in 0 Posts

Thanks for the reply.

Both of them did not work for me.

I would wan to have the below:
bash-3.00$ ps -ef |grep CSORDB1T |grep LOCAL=NO
oracle 22322 1 0 14:51:21 ? 0:39 oracleCSORDB1T (LOCAL=NO)
oracle 8839 1 0 22:05:28 ? 1:53 oracleCSORDB1T (LOCAL=NO)
oracle 8066 1 0 10:52:56 ? 0:00 oracleCSORDB1T (LOCAL=NO)

How to get the similiar output by using ps -eo?
Thank you.

*Jess*

View Public Profile for *Jess*

Find all posts by *Jess*

10-17-2008

Registered User

2,050, 105

Join Date: Jun 2008

Last Activity: 9 June 2020, 12:25 AM EDT

Location: INDIA, Bangalore

Posts: 2,050

Thanks Given: 16

Thanked 105 Times in 102 Posts

you are using wrong option with -o
for the desired output use

Code:

ps -eo 'pid,args'|awk '/CSORDB1T/&&/LOCAL=NO/{print}'

vidyadhar85

View Public Profile for vidyadhar85

Find all posts by vidyadhar85

10-17-2008

Registered User

54, 0

Join Date: Jun 2006

Last Activity: 20 July 2010, 10:52 PM EDT

Posts: 54

Thanks Given: 0

Thanked 0 Times in 0 Posts

Thanks.

For the output:
bash-3.00$ ps -eo 'pid,args'|awk '/CSORDB1T/&&/LOCAL=NO/{print}'
22322 oracleCSORDB1T (LOCAL=NO)
19855 oracleCSORDB1T (LOCAL=NO)
8839 oracleCSORDB1T (LOCAL=NO)
8066 oracleCSORDB1T (LOCAL=NO)
19915 awk /CSORDB1T/&&/LOCAL=NO/{print}

The last pid which is this current session, how could we eliminate this? Which is only to output the pid of other user session not including my current session?

Thank you.

*Jess*

View Public Profile for *Jess*

Find all posts by *Jess*

10-17-2008

Registered User

2,050, 105

Join Date: Jun 2008

Last Activity: 9 June 2020, 12:25 AM EDT

Location: INDIA, Bangalore

Posts: 2,050

Thanks Given: 16

Thanked 105 Times in 102 Posts

Quote:

Originally Posted by *Jess*

Thanks.

For the output:
bash-3.00$ ps -eo 'pid,args'|awk '/CSORDB1T/&&/LOCAL=NO/{print}'
22322 oracleCSORDB1T (LOCAL=NO)
19855 oracleCSORDB1T (LOCAL=NO)
8839 oracleCSORDB1T (LOCAL=NO)
8066 oracleCSORDB1T (LOCAL=NO)
19915 awk /CSORDB1T/&&/LOCAL=NO/{print}

The last pid which is this current session, how could we eliminate this? Which is only to output the pid of other user session not including my current session?

Thank you.

simple...

use

Code:

ps -eo 'pid,args'|awk '/CSORDB1T/&&/LOCAL=NO/&&!/awk/{print}'

vidyadhar85

View Public Profile for vidyadhar85

Find all posts by vidyadhar85

10-17-2008

MrC

Guest

n/a, 0

Posts: n/a

Simplify...

Code:

$ ps -eo 'pid,args' | egrep 'CSORDB1T.*[(]LOCAL=NO[)]'

MrC

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Programming

Python script to grep fields and use values from file 1 as argument for another command

Hi Experts, I am working one one python script in version 3.x and 2.6. Need your support to complete it Basically for both commands i have telnet to device and run command and then receiving input File 1 and File 2 I have two commands, need to grep data and output in csv file. Next script/code...

2. UNIX for Beginners Questions & Answers

Is there a UNIX command that can compare fields of files with differing number of fields?

Hi, Below are the sample files. x.txt is from an Excel file that is a list of users from Windows and y.txt is a list of database account. $ head -500 x.txt y.txt ==> x.txt <== TEST01 APP_USER_PROFILE USER03 APP_USER_PROFILE TEST02 APP_USER_EXP_PROFILE TEST04 APP_USER_PROFILE USER01 ...

3. UNIX for Beginners Questions & Answers

Grep or awk a unique and specific word across many fields

Hi there, I have data with similar structure as this: CHR START-SNP END-SNP REF ALT PATIENT1 PATIENT2 PATIENT3 PATIENT4 chr1 69511 69511 A G homo hetero homo hetero chr2 69513 69513 T C . hetero homo hetero chr3 69814 69814 G C . . homo homo chr4 69815 69815 C A hetero . . hetero is...

4. Shell Programming and Scripting

Grep fields from file

I have two files file1 : USER CURR_TIMES FAIL_CO F_TIME LAST_O_TIME ---------- -------------------------- ------------ ------------------- ------------------- T123 2017-02-25 19:16:58 GMT 3 2017-02-25 13:28:29 2017-02-25 13:42:31 K123 2017-02-25 19:16:58 GMT 3 2017-02-25...

5. Shell Programming and Scripting

awk to grep rows by multiple fields

Hello, I met a challenge to extract part of the table. I'd like to grep the first three matches based on field1 and field2. Input: D A 92.85 1315 83 11 D A 95.90 757 28 3 D A 94.38 480 20 7 D A 91.21 307 21 6 D A 94.26 244 ...

6. Shell Programming and Scripting

ignore fields to check in grep

Hi, I have a pipe delimited file. I am checking for junk characters ( non printable characters and unicode values). I am using the following code grep '' file.txt But i want to ignore the name fields. For example field2 is firstname so i want to ignore if the junk characters occur...

7. UNIX for Dummies Questions & Answers

grep on Hex fields

I'm trying to find all modules that contain line feed characters. It shows up at ^M (Hex 0D0A). Does anyone know how to do a search for hex fields? I tried doing "egrep ^M *.cbl", but that doesn't work. Thanks!

8. Shell Programming and Scripting

Cat 114 files using grep or awk to pull muliple fields

Files xxxxxxx.txt ------------------------------------------------------------------------------------------------------------------------------------ Req.By: xxxxxxx WABUSH MINES - xxxxxx MINE (1001) Page: 1 Run on: 12/14/09...

9. Shell Programming and Scripting

How can you grep for three fields

I have data, from which I want to grep for two fields. Only pull out the data if both the fields exist. I have used: egrep --text "field1|field2" file > temp. This seems to be doing an OR. What I am after is an AND.

10. UNIX for Advanced & Expert Users

Grep Line with Matching Fields

Below is the scenario. Help is appreciated. File1: ( 500,000 lines ) : Three fields comma delimited : Not sorted 1234FAA,435612,88975 1224FAB,12345,212356 File2: ( 4,000,000 lines ) : Six fields comma delimited (Last 3 field should match the 3 fields of File1) : Not Sorted : ...

Login or Register to Ask a Question