print out result from data file

thms_sum · #1 (**permalink**) 01-30-2008

i got a data file which contains all the pid,ppid,user,command,pcpu,start_time,status. I wanted to display out the pcpu which is greater than 0.

i uses awk'{if($5 > 0){print}}' filename.txt but is printing out result which not i wanted. Is there any way which i can print out those pcpu which is greater than 0?

jaduks · #2 (**permalink**) 01-30-2008

Both of them should work

Code:

awk '{if($5 > 0){print}}' file
awk '$5 > 0 {print}' file

Could you please put some sample data of your file.

panknil · #3 (**permalink**) 01-30-2008

Dear thms sum,

can u plz provide an example of ur need?

regards,
Pankaj

thms_sum · #4 (**permalink**) 01-30-2008

i have attached a sample of my data file. i would like to only display cpu which is above 0 from the data file. how can go with awk to make it display?

radoulov · #5 (**permalink**) 01-30-2008

Code:

awk '$(NF-2)>0' input

thms_sum · #6 (**permalink**) 01-30-2008

thanks radoulov!!! its works!!! but can u explain y got to NF-2?

radoulov · #7 (**permalink**) 01-30-2008

Some CMD column values contain spaces so for Awk (with default FS) %CPU is not always $5,
therefore as long as START and STAT values don't contain spaces $(NF-2)
(the number of fields of the crrent record - 2) will work

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How to print data between 2 lines in a file	kamesh83	UNIX for Advanced & Expert Users	5	12-18-2008 12:14 PM
Print out a row of data	Streetrcr	UNIX for Dummies Questions & Answers	4	03-17-2008 06:57 AM
print a function result in new file	kamel.seg	Shell Programming and Scripting	0	12-31-2007 11:57 AM
Outputting formatted Result log file from old 30000 lines result log<help required>	vikas.iet	Shell Programming and Scripting	5	12-02-2007 10:43 PM
Logging HP-UX print data	pmaths	UNIX for Dummies Questions & Answers	0	04-23-2007 08:45 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: