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

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...

yes you can

Are you sure this will work????