Section 9 – Lab Work part 5 - *AWK* # Challenge Lab Using the following data file (delimited by a space or tab) named **(section9.5.input)** ``` November 650 January 225 June 380 March 200 April 227 May 356 July 409 August 325 September 400 February 396 October 347 December 204 ``` Write a script named **(section9.5.sh)** that will use *AWK* to process the data file line by line. The script will send the output to a file **(section9.5.out)** in the following format: ``` Month Sales -------- ------- January 225 February 396 March 200 April 227 May 356 June 380 July 409 August 325 September 400 October 347 November 650 December 204 ======= Total show the total ``` ### What to upload into Moodle: Upload your fully functioning, well-documented script **(section9.5.sh)**, input file **(section9.5.input)**, and output file **(section9.5.out)** into Moodle.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Please use these commandswithin the .sh file 
sort -M .. to a temp file
awk….. the sorted temp file

rm .. temp file from sort command.

Section 9 – Lab Work part 5 - *AWK*

# Challenge Lab

Using the following data file (delimited by a space or tab) named **(section9.5.input)**

```
November 650
January  225
June     380
March    200
April    227
May      356
July     409
August   325
September 400
February 396
October  347
December 204
```

Write a script named **(section9.5.sh)** that will use *AWK* to process the data file line by line. The script will send the output to a file **(section9.5.out)** in the following format:

```
Month       Sales
--------    -------
January     225
February    396
March       200
April       227
May         356
June        380
July        409
August      325
September   400
October     347
November    650
December    204
          =======
Total     show the total
```

### What to upload into Moodle:

Upload your fully functioning, well-documented script **(section9.5.sh)**, input file **(section9.5.input)**, and output file **(section9.5.out)** into Moodle.
Transcribed Image Text:Section 9 – Lab Work part 5 - *AWK* # Challenge Lab Using the following data file (delimited by a space or tab) named **(section9.5.input)** ``` November 650 January 225 June 380 March 200 April 227 May 356 July 409 August 325 September 400 February 396 October 347 December 204 ``` Write a script named **(section9.5.sh)** that will use *AWK* to process the data file line by line. The script will send the output to a file **(section9.5.out)** in the following format: ``` Month Sales -------- ------- January 225 February 396 March 200 April 227 May 356 June 380 July 409 August 325 September 400 October 347 November 650 December 204 ======= Total show the total ``` ### What to upload into Moodle: Upload your fully functioning, well-documented script **(section9.5.sh)**, input file **(section9.5.input)**, and output file **(section9.5.out)** into Moodle.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
File Input and Output Operations
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education