please answer asappp

INSTRUCTIONS 1. Read employee information from a file named applicants.csv. The file is in the following format: id, title, first_name, last_name, email, position, status 1,Mrs, Lorin, Eatttok, leatttok@@google.cn, Account Executive, Interview 2,Mr,Misti, Fanshaw, mfanshaw1@dmoz.org, Graphic Designer, Hire 3,Ms, Lonny, Hazelden, Lhazelden2@sbwire.com, Electrical Engineer, Interview 4, Dr, Emi le, Caldecot, ecaldecot3eparallels. com, Desktop Support Technician, Reject 5, Honorable, Eden, Geraldini, egeraldini4egoogle. fr, Geological Engineer, Interview Here is an example input file: - Generated at https://www.mockaroo.com/ - Note: this is just an example file, a different input file may be used for grading 2. For each applicant, generate a personalized "email" and append it to an output file called emails.txt Each "email" should be formatted as follows: To: mfanshaw1edmoz.org From: humanresources@gizmogroupllc.com Subject: Your Gizmo Group Application Dear Mr. Fanshaw, \{Message here\} Address the message the the applicant using their title and last name, e.g. "Dear Mr. Fanshaw" The body of the message should mention the position the applicant is applying for Based on the status, the body of the message should also - Make the applicant a job offer - Invite the applicant to schedule an interview - Inform the applicant that their application has been denied 3. Check for and handle the following errors in the input file: 1. Missing title - Address the the message using the applicant's first and last name, e.g. "Dear Misti Fanshaw" 2. Invalid email address - If the email address is missing an "@" symbol, write a message to standard error (e.g. using System.err.print*), but do not write an "email" to the output file. For example: - The following email address is invalid: "% ' at position 4 in last name: "Robe\%tson" 4. Other requirements: 1. Use a StringBuilder to create each "email" 2. Remove any extra whitespace from the beginning or end of each field 5. Be sure to review the rubric and follow the Submission Guidelines