UNIX for Dummies Questions & Answers

Hi..

I have a dat file containing both column names and data. Now I want to get only Particular row along with the column names.
My dat fiel is as below

EmpName Dept Salary
Shally Admin 20000
Swati HR 15000
Deepali IT 45000
Preetika EEE 60000

Now I want to display only row 3rd along with column name using awk command.

I tried as below to get the column name ;
awk 'NR==1 {print $0}' Employee.dat
This retrives the column name... now how to get particular row.

try something like this

Code:

awk 'NR==1{print}NR==3{print}' filename

Thanks alot. Its working fine with the current scenario...

I have one more query. If we know exactly which row to retrieve then this will work fine. Suppose the given dat file contains thousands of records, I just want to retrieve all the rows whose salary is greater tha 15000. How can v acheive that ? In other words can v use expressions(logical,arthmetic, regular...) to retireve the particular rows along with the column name..

Use awk...

Code:

$ cat emp.dat

EmpName Dept Salary
Shally Admin 20000
Swati HR 15000
Deepali IT 45000
Preetika EEE 60000
john     ECE  5000

$ awk '{if ($3 > 15000) {print $0}}' emp.dat

EmpName Dept Salary
Shally Admin 20000
Deepali IT 45000
Preetika EEE 60000

yes you can

Code:

 
awk 'BEGIN{NR==1{print}$3>15000{print}' filename

Are you sure this will work????