Question

do the following on a UNIX command line, if applicable vi editor may be used

Consider the text file PEOPLE

101:Alice:Peters: President
102:Bob:Smith: VP
103:Jane:Jones: Programmer
104:John:Roberts: Project Manager

1. use the cut command to display the first name and last name only

2. using cut and sort commans and a pipe display the last name and job title in each record then sort the output by the last name

3. sort the file by employee ID in decreasing order. Make sure sort treats this field as a numeric field

Answer 1

a)cut -d ":" -f 2-3 people.txt

-d is delimiter of ':' -f is the fields and 2-3 gives columns 2 to 3

b)cut -d ":" -f 3-4 people.txt | sort -k 1

sort takes input from cut command output and -k represents on which field sorting should be done

c)cut -d ":" -f 1-4 people.txt | sort -nr -k 1n

Here -n is used to perform numeric sorting

r is for decreasing order

-k is for field number