Question: Create a script using awk and sort with a command pipeline as follows: Use the employees file in my cis204 folder( I have already copied

Create a script using awk and sort with a command pipeline as follows:

Use the employees file in my cis204 folder( I have already copied this to my file). The records in this file have 5 fields separated by colons (:). The fields are ssn, department, lastname, firstname and years_employed.

Use the employees file to create output where the employees are from DEPARTMENT 100 only, the number of years_employed has been increased by 1 year and the file is in sorted order. The format of the output should be close to the above, The content must match exactly.

It needs to look like the bottom image. I can't seem to get it narrowed down to just the depart 100 employees.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

UNIX Create a script using awk and sort with a command pipeline as follows: Use the employees file. The records in this file have 5 fields separated by colons (:). The fields are ssn, department,...

I already have the "employees" file in my bin. I just need help sorting it now. I am unsure of where to include the file name and the DEPARTMENT in my commands. Here is the assignment: Create a...

Project 2 - File Processing (Shell Programming class) For this project, download the text file weblog.txt Note: To download this file, right click on the link and select SAVE AS. This file is an...

Worksheet Objectives Become familiar with the file system directory tree used in class Determine the current working directory with the pud command . Use the ls (list files) command with various...

the first is the main question the rest are how to implement the code question requirements test cases You are required to create a small C++ application that will mimic a computer file system, which...

I have already completed part one shown below. I need help with part 2: MonthlyCostComparator.java, MonthlyCostComparatorTest.java, and CloudStoragePart2.java, CloudStoragePart2Test.java Thank you,...

%% Lab 2 - Your Name - MAT 275 Lab %% Example code % Example 1 % NOTE: Delete examples before submission. A = [1 0; 0 -1] A = [1, 0; 0, -1] % NOTE: The two matrices above are the same. We can...

please help ASAP. This is a virtual box assignment with a vagrant. 0 opcode mnemonic description NOOP / HALT Indicates system halt state 1 LOAD Load AC from memory 2 STORE Store AC to memory 3 JMP...

Introduction and learning objectives When you were learning about operational analysis earlier in the term, we talked about jobs that require multiple visits to the CPU (or servers) to receive their...

a. Enter the command to change to your user2 directory by either relative or absolute pathname from your home directory. What command did you use? b. Enter this command to verify the directory you...

Owl Co. retired its $2,500,000 par value, 6%, 10-year callable bonds early, on October 6 of the current year, paying $2,550,500, which included the accrued interest of $35,785 due at the date of the...

2-17. On January 2, 2020, the shareholders of Fire Red Company approved a plan granting certain officers of the company nontransferable options to buy 50,000 shares of P100 par ordinary share capital...

What are some shortcomings of the goal of profit maximization?

Things Get Messi Enterprises is issuing new bonds for a capital budgeting project. The bonds will have 2 5 . 0 0 year maturities with a coupon rate of 6 . 5 0 % APR with semi - annual coupon payments...