Powershell parsing local HTML file

Question

Im trying to iterate through multiple HTML files in multiple computers.

My code is below:

ForEach ($system in (Get-Content C:\temp\computers.txt)) {

    $folder = "\\$system\c`$\ProgramData\Autodesk\AdLM\"
    Get-ChildItem $folder *.html  |
    Foreach-Object {
        $c = $_.BaseName
        $html = New-Object -ComObject "HTMLFile"
        $HTML.IHTMLDocument2_write($(Get-content $_.Name -Raw ))
        $para1 = $HTML.getElementById('para1') | % InnerText
        Add-Content -path c:\temp\results.csv "$c,$system,$para1"
    }
 }

I'm getting the following error:

New-Object : Cannot find parameter Raw

@BryceMcDonald - The New-Object cmdlet is a built-in PowerShell cmdlet. The querent should look at gallery.technet.microsoft.com/Powershell-Tip-Parsing-49eb8810 for handling HTML files using the Document Object Model. — Jeff Zeitlin
– Jeff Zeitlin, Commented Nov 27, 2017 at 15:12
@JeffZeitlin I'm aware of the cmdlet, for some reason I couldn't see where he had it in his code but I do now. I'll keep drinking this coffee and hope it helps. — Bryce McDonald
– Bryce McDonald, Commented Nov 27, 2017 at 15:14
Also relevant: stackoverflow.com/questions/24977233/parse-local-html-file — Jeff Zeitlin
– Jeff Zeitlin, Commented Nov 27, 2017 at 15:18
let me check again as I've realised I'm using powershell2 which does not have Raw parameter. — Ankh2054
– Ankh2054, Commented Nov 27, 2017 at 15:29

Bryce McDonald · Accepted Answer · 2017-11-27 15:29:50Z

2

You can use the Internet Explorer COM object to do what you'd like the HTMLFile COM object to do. HTMLFile isn't working 100% in all versions of Powershell, so this is a viable alternative.

ForEach ($system in (Get-Content C:\temp\computers.txt)) {
  $folder = "\\$system\c`$\ProgramData\Autodesk\AdLM\"
  Get-ChildItem $folder *.html  |
  ForEach-Object {
    $c = $_.BaseName
    $ie=New-Object -ComObject InternetExplorer.Application
    $ie.Navigate("$_")
    while ($ie.busy -eq $true) {
      Start-Sleep -Milliseconds 500
    }
    $doc=$ie.Document
    $elements=$doc.GetElementByID('para1')
    $elements.innerText | ForEach-Object { Add-Content -path c:\temp\results.csv "$c,$system,$para1" }
  }
}

answered Nov 27, 2017 at 15:29

Bryce McDonald

1,87015 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Powershell parsing local HTML file

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related