In this lab, you’ll use 2 folders: An “Inbound” from whereyou’ll be writing your script, and an “Auto” folder where all filesthat are ready for automatic processing will be placed.
The input file is called
Name the pre-processed file
Consider the file . It isan Enrollment File that must be pre-processed before it can be runautomatically. You are to write an AWK script, , to do the pre-processing according tothe requirements below:
First, change “EffectiveDate” header to “Effective Date”.
Then for each of the requirements below, write a function tocomplete it:
The Effective date for Drop status must be changed to the lastday of the month of the associated “Effective Date”. For example,in the sample file, the last record has a Drop status. Itseffective date is 03/25/2018. This must be changed to03/31/2018.
Format the area code and Home phone number fields to 3 digitsand 7 digits respectively. For example, in the sample file, thefirst 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 (asindicated above) and place a copy into the “Auto” folder.
Submit your script lab4_1.awk and a zipped copy of your Autofolder.
THANKS IN ADVANCE!!!!!
. . .