Lab
Exercise-2
1. Create
a data file called employee in the format given below:
a. EmpCode Character
b. EmpName Character
c. Grade
Character
d. Years of experience
Numeric
e. Basic Pay Numeric
$vi employee
A001
ARJUN E1
01 12000.00
A006
Anand
E1 01 12450.00
A010
Rajesh
E2 03 14500.00
A002
Mohan
E2 02 13000.00
A005
John
E2 01 14500.00
A009
Denial SmithE2 04
17500.00
A004
Williams E1
01 12000.00
2.) Sort the file on EmpCode.
$cut –f1 employee | sort
1. Sort
the file on EmpName.
$cut –f2 employee | sort
1. Sort
the file on
(i) Decreasing order of basic pay
(ii) Increasing order of years of experience.
(i) $cut –f5 employee | sort –r
(ii) $cut –f4 employee | sort
1. Display
the number of employees whose details are included in the file.
wc –l
1. Display
all records with ‘smith’ a part of employee name.
cut –f2 –d “ ” employee | grep ‘^[smith]’ | wc
–l
1. Display
all records with EmpName starting with ‘B’.
$cut –f2 employee | grep ‘^[B]’ | wc –l
1. Display
the records on Employees whose grade is E2 and have work experience of 2 to 5
years.
$cut –f3 employee | grep ‘[*2] | cut –f4
employee | grep ‘[2-5]’
1. Store
in ‘file 1’ the names of all employees whose basic pay is between 10000 and
15000.
$cut –f2,5 employee | grep ‘[10000-15000]’
> rec
10. Display records of all employees who are
not in grade E2.
$cut –f3 employee | grep ‘[*1]’