STUDENTS2.DAT FILE

John Doe ECE 3.54 doe@jd.home.org 111.222.3333 James Davis ECE 3.71 davis@jd.work.org 111.222.1111 Al Davis CS 2.63 davis@a.laers.org 111.222.2222 Ahmad Rashid MBA 3.74 ahmad@mba.org 111.222.4444 Sam Chu ECE 3.68 chu@sam.ab.com 111.222.5555 Arun Roy SS 3.06 roy@ss.arts.edu 111.222.8888 Rick Marsh CS 2.34 marsh@a.b.org 111.222.6666 James Adam CS 2.77 jadam@a.b.org 111.222.7777 Art Pohm ECE 4.00 pohm@ap.a.org 111.222.9999 John Clark ECE 2.68 clark@xyz.ab.com 111.111.5555 Nabeel Ali EE 3.56 ali@ee.eng.edu 111.111.8888 Tom Nelson ECE 3.81 nelson@tn.abc.org 111.111.6666 Pat King SS 2.77 king@pk.xyz.org 111.111.7777 Jake Zulu CS 3.00 zulu@jz.sa.org 111.111.9999 John Lee EE 2.64 jlee@j.lee.com 111.111.2222 Sunil Raj ECE 3.36 raj@sr.cs.edu 111.111.3333 Charles Right EECS 3.31 right@cr.abc.edu 111.111.4444 Diane Rover ECE 3.87 rover@dr.xyz.edu 111.111.5555 Aziz Inan EECS 3.75 ainan@ai.aedubc.org 111.111.1111 Lu John CS 3.06 lu.john@xyz.org 111.333.1111 Lee Chow EE 3.74 chow@lc.www.ord 111.333.2222 Adam Giles SS 2.54 giles@cric.org 111.333.3333 Andy John EECS 3.98 john@aj.ece.edu 111.333.4444

UNIX File Commands Assignments Use the UNIX file commands learned in class to write a command or several commands with a pipe, to respond to each question. 1. Copy the file students2.dat from my public directory to your directory. Perform the following tasks. a. Display the contents of the file sorted by last name. Ignore leading white space. Column 1 is first name and column 2 is last name. b. Display lines, with line numbers, records of Computer Science majors. c. Display lines, with line numbers, for students whose first or last name is John. d. Display lines for students whose e-mail addresses end with .edu. e. Display all ECE majors sorted in descending order by GPA. f. Display all lines but show only the last name and GPA, sorted ascending by GPA