Answered step by step
Verified Expert Solution
Question
1 Approved Answer
a) Consider the following file called salaries.csv: uid, loc, div, year, sal dgarcia, WDC, fin, 2018, 102900 ejones, SEA, sales, 2017, 56450 3 dlarkin, RCH,
a) Consider the following file called salaries.csv: uid, loc, div, year, sal dgarcia, WDC, fin, 2018, 102900 ejones, SEA, sales, 2017, 56450 3 dlarkin, RCH, rsrch, 2019,78435 ccartwright, RCH, acct, 2019,48775 mlesko, OTT, rsrch, 2018,93870 criggs, WDC, sales, 2019, 62334 jpetrovski, RCH, acct 2017,68348 tchepregi, SEA, rsrch, 2018, 84290 amurchin, OTT, sales, 2019, 49038 gcarlson, RCH, fin, 2019, 70000 swelsh,wDC, sales, 2017,39876 Each field in this file is separated by a comma and each record is separated by a newline character. For this file, you will write a one-line gawk command-line to filter records for employees who earn $50,000 or more in 2019 . Specifically, you will print out only the userid (i.e., uid), location (i.e., loc), and salary (i.e., sal) for those employees working in 2019 who earned a salary of $50,000 or more. You may write the gawk command-line in the space provided below and ensure that this Word document (with your solutions) is submitted to Canvas
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started