Project #4 AWK and SED This project requires multiple steps using awk, sed, and shell. You will produce output files suitable for sending personalized emails to customers (one output file for each customer meeting our criteria) Customer File (p4Customer.txt) Contains one line per customer Each customer line contains: o Customer Email email address also uniquely defines a customer o Full Customer Name (e.g., Bob L Head) o Title (e.g., Mr., Col., Ms.) o Paid Amount- how much the customer has previously paid o Owe Amount how much the customer owes Sample Data Moss,Mr. ,10580.00,100 pcorn@abc.net Pop Corn, Col.,50,200 You can find p4Customer.txt and template.txt in /usr/local/courses/clark/cs3423/2017Fa/Proj4/ Our criteria Produce an email file for each customer in the customer file having an Owe Amount greater than the Paid Amount. Our company doesn't want to pester customers like Pete Moss who have previously paid the company more money. In the simple example above, we wouldn't send an email to Pete Moss, but we would send one to Pop Corn There will be a template file (template.txt) which contains references to variables (all caps) which should be substituted with values for each customer meeting our criteria. Variables EMAIL customer email address (1st attribute) TITLE customer title (3rd attribute) FULLNAME full customer name NAME customer name AMOUNT - owe amount DATE - date the payment must be received. This is passed as the only parameter to proj4.bash Sample email template text in SMTP format MAIL FROM: RCPT TO: DATA From: "Bill King" To: "FULLNAME" Subject: Payment is Due Dear TITLE NAME, We appreciate your business with Completely Reliable Outlet Corp. You would be an even more valued customer if you will pay us $AMOUNT. If you don't pay us by DATE, we will double the amount you owe us. If you have any questions regarding your account, please contact