You are to create a Windows PowerShell script that produces a report in HTML Web page format from the students.txt file. See the link for an example html output within the assignment information provided in the Seminar Five Folder.

 

The script must meet the following requirements:

1. The script must use the data file “students.txt” that is provided for processing. (See link to file within the assignment information provided in the Seminar Five folder.) - 30 points
2. The output file should be named students.htm - 5 points
3. Every data line with a student number (example: 9999-9999) must be included in the report - 20 points
4. Every data line should be broken up into even, matching columns (like a spreadsheet) - 10 points
5. All data must be trimmed, no leading or trailing white space, and no empty values or garbage lines.  - 20 points
6. There should be just one header line, scraped from the file, not hard coded -10 points
7. The student number must be detected using a regular expression or PowerShell method - 5 points
8. The script must include comments to explain your code - 10 points
9. The report headers must be visible in the HTML Web page and match the cells below - 10 points
10. The final deliverable will be your .ps1 script, not the HTML file. The teacher will generate the HTML file using your script - 20 points
11. You must use relative paths pointing to the current directory on all your code - 10 points

 

 

Please see attached ( Students.txt) and ( desired output for the script)

Attachments:

• 1512798708-desired output for the script.pdf
• 1512798712-Student.ext.pdf