home / study / engineering / computer science / computer science questions and answers / you are to create a windows powershell script that produces a report in html web page format ... Your question has expired and been refunded. We were unable to find a Chegg Expert to answer your question. Question: You are to create a Windows PowerShell script that produces a report in HTML Web page format from... 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 Module 6 Folder. The script must meet the following requirements: The script must use the data file students.txt that is provided for processing. - 30 points The output file should be named students.htm - 5 points Every data line with a student number (example: 9999-9999) must be included in the report - 15 points Every data line should be broken up into even, matching columns (like a spreadsheet) - 10 points All data must be trimmed, no leading or trailing white space, and no empty values or garbage lines. - 15 points There should be just one header line, scraped from the file, not hard coded -10 points The student number must be detected using a regular expression or PowerShell method - 5 points The script must include comments to explain your code - 10 points The report headers must be visible in the HTML Web page and match the cells below - 10 points The final deliverable will be your .ps1 script, not the HTML file. The teacher will generate the HTML file using your script - 15 points You must use relative paths pointing to the current directory on all your code

this is what i have got so far, im close i can get the data pulled i need but cant get a header and column done,

$style = ""

$SourceFile = "C:\Users\alexa\its341\scripts\students.txt" $TargetFile = "C:\Users\alexa\its341\scripts\students1.htm"

$File = Get-Content $SourceFile $FileLine = @() Foreach ($Line in $File) { if ($Line -match "\d\d\d\d-\d\d\d\d") { $MyObject = New-Object -TypeName PSObject Add-Member -InputObject $MyObject -Type NoteProperty -Name TestProject2 -Value $Line $FileLine += $MyObject } }

here is what it should look like:

project2 for my class x O PowerShell Script Pro powershell Creating i x e Chegg Study Guided x e Home Study /Engine x 1 cant Figure Out How + https://baker.instructure.com/courses/14851/files/377663 ITS3410-A2 > Files > PowerShell-Script-Project2-students.htm Foll 2018 PowerShell_Script Project2_students.htm Home Announcements Modules Grades People Google Drive Library Resources Download PowerShell_Script Project2 students.htm (24 KB) ITS341 Seminar 6 PowerShell Script Project UIN 5528-7375 DENTY 5528-4165 AWKWARD 5538-6679 SCHOEPPNER 5557-6817 MEDICI 5562-3799 SAMEK 5521-4521 LEHIGH 5521-5366 FULSON 5523-4222 BESERRA 5569-8359 SCHNOKE 5524-3172 EGOLF FIRST DA BRYON THADDEUS IN 7012 4 CER CSC 2006A 2.30 ACKSON N8512 4 CER CSC 2007A 2.68 NENITA HERTHA IN MARVIS MARCEL N4412 4 CER CSC 2007A 2.52 JA FRIDA BRYON LAST N 72 84 CER CSC |2006A 3.43 Calendar N 72 10 4 CER CSC |2007A 3.06 Inbox 78 8 4 CER CSC |2007A 3.28 Help N 40 84 CER CSC |2007A 2.84 N 64 12 4 CER CSC |2007A 2.84 4-39 PM O Type here to search 4x 10/19/2018 ^ project2 for my class x O PowerShell Script Pro powershell Creating i x e Chegg Study Guided x e Home Study /Engine x 1 cant Figure Out How + https://baker.instructure.com/courses/14851/files/377663 ITS3410-A2 > Files > PowerShell-Script-Project2-students.htm Foll 2018 PowerShell_Script Project2_students.htm Home Announcements Modules Grades People Google Drive Library Resources Download PowerShell_Script Project2 students.htm (24 KB) ITS341 Seminar 6 PowerShell Script Project UIN 5528-7375 DENTY 5528-4165 AWKWARD 5538-6679 SCHOEPPNER 5557-6817 MEDICI 5562-3799 SAMEK 5521-4521 LEHIGH 5521-5366 FULSON 5523-4222 BESERRA 5569-8359 SCHNOKE 5524-3172 EGOLF FIRST DA BRYON THADDEUS IN 7012 4 CER CSC 2006A 2.30 ACKSON N8512 4 CER CSC 2007A 2.68 NENITA HERTHA IN MARVIS MARCEL N4412 4 CER CSC 2007A 2.52 JA FRIDA BRYON LAST N 72 84 CER CSC |2006A 3.43 Calendar N 72 10 4 CER CSC |2007A 3.06 Inbox 78 8 4 CER CSC |2007A 3.28 Help N 40 84 CER CSC |2007A 2.84 N 64 12 4 CER CSC |2007A 2.84 4-39 PM O Type here to search 4x 10/19/2018 ^