Question: Activity In this lab, youll use 2 folder: An Inbound from where youll be writing your script, and an Auto folder where all files that
Activity
In this lab, youll use 2 folder: An Inbound from where youll be writing your script, and an Auto folder where all files that are ready for automatic processing will be placed.
The input file is called sample_enrollment.csv
Name the pre-processed file (output file) enrollment_
Consider the file sample_enrollment.csv. It is an Enrollment File that must be pre-processed before it can be run automatically. You are to write an AWK script, enrollment.awk, to do the pre-processing according to the requirements below:
First, change "EffectiveDate" header to "Effective Date".
Then for each of the requirements below, write a function to complete it:
The Effective date for Drop status must be changed to the last day of the month of the associated Effective Date. For example, in the sample file, the last record has a Drop status. Its effective date is 03/25/2018. This must be changed to 03/31/2018.
Format the area code and Home phone number fields to 3 digits and 7 digits respectively. For example, in the sample file, the first record has no value for the area code and "+1 206 8497834" for the home phone. This should be changed to Area code = 206, and Home phone = 8497834.
Remove all records with Change status so that only the Add and Drop statuses will be processed.
Finally, save the changed contents in a new filename (as indicated above) and place a copy into the Auto folder.
|
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help