Question: Write an awk script that produces a report from an input file. The report summarizes sales data as recorded for sales stations. The input file

Write an awk script that produces a report from an input file. The report summarizes sales data as recorded for sales stations. The input file contains sales data for several years, however, your report should only list data for the year 2014.

The awk script file name must be "z123456.report", where z123456 is your Z-id. The awk script is invoked from the command line with an input file that contains data for multiple years:

awk -f z123456.report inputfile. txt

The lines in the input file have the following fields:

year: four digit integer number

month: three letter abbreviation of a month

station: one letter station code

sale amounts: floating point numbers, with 2 significant digits. Each input line will have at least one and at most 10 amount fields.

Here is an example of input sales data ==> click here to download

 2011 Jan X 29.44 17.33 43.21 2014 Jan Y 32.32 12.12 99.00 1.99 2012 Jan X 321.11 12.34 10.99 2012 Feb Y 1.99 12.75 2012 Feb X 32.99 65.78 98.76 2014 Jan Y 12.99 17.44 21.34 2012 Mar X 11.45 ...

Your awk script should produce a report that lists the 2014 sales amount per month and station. In addition the report should list the sum of all sales per station for the year 2014, the total sales for the year, and how many records from the input file were processed.

see below input file. Write an awk script that produces a report from an input

s3.us-east-1.amazonaws.com Upload Assignment: Assignment 6- Fall 2018 CSCI 330 https://s3.us-east-1 Chegg Study | Guided Solutions and Study Help I Chegg.com 2011 Jan X 29.44 17.33 43.21 2014 Jan Y 32.32 12.12 99.00 1.99 2012 Jan X 321.11 12.34 10.99 2012 Feb Y 1.99 12.75 2012 Feb X 32.99 65.78 98.76 2014 Jan Y 12.99 17.44 21.34 2012 Mar X 11.45 2013 Jan X 14.75 34.21 2013 Feb Y 21.00 12.21 21.12 32.99 98.75 2014 Mar X 7.77 1.11 1.11 0.01 2011 Apr X 29.45 17.33 43.21 2011 Apr Y 32.32 12.12 99.01 2.99 2012 May X 321.11 12.34 10.99 2012 Jun Y 1.99 12.72 2012 Jun X 32.99 65.78 98.76 2012 Jul X 11.45 2013 Jul X 14.75 34.22 2013 Aug Y 21.00 12.21 21.12 33.99 98.75 2014 Aug X 7.77 323.99 12.12 2013 Sep X 29.44 17.33 43.21 2011 Sep Y 32.32 12.12 99.00 1.99 2012 Jan X 321.11 12.34 10.99 2014 Dec 2 9.99 9.99 9.99 2012 Oct Y 1.99 12.75 2012 Oct X 32.99 65.78 98.76 2012 Nov X 11.45 2013 Nov X 14.75 34.21 2013 Nov Y 21.00 12.21 21.12 32.99 98.75 2014 Nov X 8.77 323.99 77.33 2011 Nov X 29.45 17.33 43.21 2011 Dec Y 32.32 12.12 99.01 2.99 2012 Oct X 321.11 12.34 10.99 2012 Oct Y 1.99 12.72 2012 Nov X 32.99 65.78 98.76 2012 Dec X 11.45 2013 Dec X 14.75 34.22 2013 Dec Y 21.00 12.21 21.12 33.99 98.75 2014 Dec X 7.77 323.99 s3.us-east-1.amazonaws.com Upload Assignment: Assignment 6- Fall 2018 CSCI 330 https://s3.us-east-1 Chegg Study | Guided Solutions and Study Help I Chegg.com 2011 Jan X 29.44 17.33 43.21 2014 Jan Y 32.32 12.12 99.00 1.99 2012 Jan X 321.11 12.34 10.99 2012 Feb Y 1.99 12.75 2012 Feb X 32.99 65.78 98.76 2014 Jan Y 12.99 17.44 21.34 2012 Mar X 11.45 2013 Jan X 14.75 34.21 2013 Feb Y 21.00 12.21 21.12 32.99 98.75 2014 Mar X 7.77 1.11 1.11 0.01 2011 Apr X 29.45 17.33 43.21 2011 Apr Y 32.32 12.12 99.01 2.99 2012 May X 321.11 12.34 10.99 2012 Jun Y 1.99 12.72 2012 Jun X 32.99 65.78 98.76 2012 Jul X 11.45 2013 Jul X 14.75 34.22 2013 Aug Y 21.00 12.21 21.12 33.99 98.75 2014 Aug X 7.77 323.99 12.12 2013 Sep X 29.44 17.33 43.21 2011 Sep Y 32.32 12.12 99.00 1.99 2012 Jan X 321.11 12.34 10.99 2014 Dec 2 9.99 9.99 9.99 2012 Oct Y 1.99 12.75 2012 Oct X 32.99 65.78 98.76 2012 Nov X 11.45 2013 Nov X 14.75 34.21 2013 Nov Y 21.00 12.21 21.12 32.99 98.75 2014 Nov X 8.77 323.99 77.33 2011 Nov X 29.45 17.33 43.21 2011 Dec Y 32.32 12.12 99.01 2.99 2012 Oct X 321.11 12.34 10.99 2012 Oct Y 1.99 12.72 2012 Nov X 32.99 65.78 98.76 2012 Dec X 11.45 2013 Dec X 14.75 34.22 2013 Dec Y 21.00 12.21 21.12 33.99 98.75 2014 Dec X 7.77 323.99

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!

Write an awk script that produces a report from an input file. The report summarizes sales data as recorded for sales stations. The input file contains sales data for several years, however, your...

The assignment is due Today 10/24 Write an awk script that produces a report from an input file. The report summarizes sales data as recorded for sales stations. The input file contains sales data...

Write an awk script that produces a report from an input file. The report summarizes sales data as recorded for sales stations. The input file contains sales data for several years, however, your...

Write an awk script that produces a report from an input file.This is in UNIX LINUX code The report summarizes sales data as recorded for sales stations. The input file contains sales data for...

Assignment Write an awk script that implements a report writer. Program The report computes summary data on the performance of sales associates for our company "No-op Computing.". The awk script file...

l. Introduction In this programming assignment, you will create a front end that is, a scanner and a parserfor the intermediate representation, ILOC, that will be used as input in the next two...

C++ Programming Windows Console Application. Please use comments throughout code please. Description: This program will read a data file that contains book store sales for 12 months. Each month...

C++ programming. Please use comments throughout code so I can comprehend code. Description: This program will read a data file that contains book store sales for 12 months. Each month record will...

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

In tax year 1, an electronics-packaging firm had a gross income of $35,000,000, $6,000,000 in salaries, $7,000,000 in wages, $800,000 in depreciation expenses, a loan principal payment of $200,000,...

Rodeo Printers operates a printing press with a monthly capacity of 4,000 machine-hours. Rodeo has two main customers: Trent Corporation and Julie Corporation. Data on each customer for January are:...

What is appreciation based on international Fisher's effect for Australian dollar if inflation in Japan and Australia are 0 . 8 4 7 2 % and 1 . 9 1 4 9 % , respectively, while nominal interest rates...

please solve asap B. Complete the following reactions. HOCH,CH OHH EtO OEt 1. NaOEVETOH 2. CH CH Br NaoEt ELO H,0* Heat Brz/ AOH ? ? 1. LDA/THF 2 2. CH CH Br 1. NaOEt 2. CH,Br ? HCI NaCN CH3COCI...

Holding national saving constant, does an increase in net capital outflow increase, decrease, or have no effect on a countrys accumulation of domestic capital?

An article in USA Today (December 16, 2004) began President Bush said Wednesday that the White House will shore up the sliding dollar by working to cut record budget and trade deficits. a. According...

International trade in each of the following products has increased over time. Suggest some reasons this might be so. a. wheat b. banking services c. computer software d. automobiles