Question

Unix/Linux

In the data file employees.dat we have employee records with the following fields of information (ID, FN, LN, D, #) where ID: Employee identification number FN: Employee first name LN: Employee last name 8: Office number Write a shell script for processing employees.dat in such a way that we get the list of records (ID, FN, LN) and the total number of employees in the standard output as well as the file employees_by office.dat that contains emplayee records with the following fields of information (#, ID, FN. LN. DARecords in the file employees-by-office.dat must be sorted by the key #, and fields are separated by the symbol . Concepts in practice: Text File Processing Commands. Awk. Scripting.

Answer 1

employess.dat :

(ID,FN,LN,D,#)

1. To extract only(ID,FN,LN):

here, ID is column1 so, $1 , for FN-$2, for LN-$3

$ awk '{print $1,$2,$3}' employees.dat  

2. creating employee_by_office.dat file

$ awk '{print $5,$1,$2,$3,$4}' employees.dat > employee_by_office.dat
$ cat employee_by_office | sort -U K1