Question: 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

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, 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.

file sorted on any simple attribute

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!

Q:

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...

Q:

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...

Q:

1. (30 points) Write a C program mergeSort.c that accepts three strings as parameters from the command line in main(). These three strings are names of three files with the first two files containing...

Q:

Using an IDE or Text Editor of your choice, create and save a UNIX Shell file for the problem given. Before submitting your solution via Canvas, sip the shell script and name the archive, if your...

Q:

Use the code program below to make the data in your program persistent by storing all car and rental records into separate files and using the information when the program starts up. The program must...

Q:

use putty or ssh to finish question!!!! General Instructions: How to Submit Your Work You must submit your assignment answers electronically: Change into your subversion directory on bluenose: cd...

Q:

1. What is awk? The UNIX awk program is another popular stream editor. The basic function of awk is to search files for lines or other text units containing 1 or more patterns. When a line matches 1...

Q:

This assignment asks you to write bash shell scripts to compute matrix operations. The purpose is to get you familiar with the Unix shell, shell programming, Unix utilities, standard input, output,...

Q:

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...

Q:

This assignment asks you to write bash shell scripts to compute matrix operations. The purpose is to get you familiar with the Unix shell, shell programming, Unix utilities, standard input, output,...

Q:

Consider gas flow through a converging nozzle with specified inlet conditions. We know that the highest velocity the fluid can have at the nozzle exit is the sonic velocity, at which point the mass...

Q:

For this question, you will locate substantial authority for the following case. You don't have to support the taxpayer's position. Just simply identify the applicable criteria for the taxpayer's...

Q:

(Student project) Bring to class a chart from a newspaper or magazine that you believe to be a poor representation of a numerical variable. Be prepared to discuss why you think this. Do you believe...

Q:

Why is it essential for businesses to conduct a legal and regulatory audit? Provide examples of industries where compliance with regulations is particularly critical. Share a recent case where a...

Q:

How is the labormanagement relationship at Kaiser Permanente different from some more traditional labormanagement relationships? Why do you think that is?

Q:

If you were an employee at Boeing in South Carolina, would you have voted for or against the union? Explain.

Q:

Assume you are the general manager of a small seafood company. Most training is unstructured and occurs on the job. Currently, senior fish cleaners are responsible for company has been profitable,...