Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help write script problems in Linux show outcomes also CIS 345 Homework 1 1-28-20 Suppose Wayne Electronics Inc. has a file named customers and

please help write script problems in Linux
show outcomes also
image text in transcribed
CIS 345 Homework 1 1-28-20 Suppose Wayne Electronics Inc. has a file named customers and contact with following fields: First Name Last Name Street Address, City, State, Zip code, Phone number, Social Security Number, and Date of Birth all delimited with tab characters as shown in the sample entry below. New contacts are appended as they occur. David Webb Box 34 Rural Route 2 Martha Kent 1122 North Hwy 5 Edward Nygma 443 W. Broadway Nixa MO Smallville Gotham City 65714 KS NJ (417)555-1478 555-66-7788 09-13-1970 66789 (785)555-2322 343-55-8845 04-17-1965 12458 (212)743-3537 785-48-5524 08-08-1987 Create a customers and contacts.txt file of your own for use in the following problems. Be sure to include sample data that will thoroughly text your bash scripts. Write bash scripts to solve the following problems: Janet in Accounts Receivable needs you to make a copy of customers and contacts reformatted as follows: Last name first then the first name, social security number, date of birth, city, state, street address, and phone number. This should be a comma delimited list suitable for import into Excel. 5 points Jane in marketing wants a copy of the list for the telemarketing team. She needs the social security numbers redacted. Everything else can remain the same. Replace the social security number with XXX-XX-XXXX. 5 points Modify the customers and contacts.txt file so that the date of birth is formatted month day, year, as follows. 5 points Carter Smith Box 34 Rural Route 2 Bois D'Arc MO 65612 (417)555-1478 555-66-7788 January 7, 1972 Jane in marketing wants another copy of the list. This time include only those entries between the ages of 18 and 49. For our purposes you need only consider the year of birth in determining the age. 5 points Jane in marketing needs a mailing list. Create a text file containing only the names and addresses sorted alphabetically by last name. Format the entries so they can be used as an address label as shown. Skip a line between each address. 5 points Ex. Carter Smith Box 34 Rural Route 2 Bois D'Arc, MO 65612 Print out your scripts, test data, and results for each

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

find all matrices A (a) A = 13 (b) A + A = 213

Answered: 1 week ago