extract values from td tags in Powershell

Question

I have a situation where I have to gather information from a webpage. I need to extract anything encapsulated td tags of the HTML tables

In this particular situation the only thing I have available to do this process is PowerShell.

Is there an easy way to do this only using PowerShell?

Andy Arismendi · Accepted Answer · 2012-04-27 21:53:42Z

2

I think you have to main options:

Use a regular expression.
Use the DOM.

Here's how you can do both:

Regex:

$data = (new-object System.Net.WebClient).DownloadString('http://www.amazon.com')
[regex]::Matches($data, '<td.*?>(.+)</td>') | % {$_.Captures[0].Groups[1].value}

DOM:

$ie = new-object -com InternetExplorer.Application
$ie.Navigate('http://www.amazon.com')
$ie.Document.getElementsByTagName('td')

answered Apr 27, 2012 at 21:53

Andy Arismendi

53.2k17 gold badges113 silver badges130 bronze badges

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

1 Comment

Radagast Over a year ago

Worked perfectly. thank you so much for your assistance. Andy Arismendi. I used the Regex version

Angshuman Agarwal · Accepted Answer · 2012-04-27 20:37:22Z

0

$ie = new-object -com "InternetExplorer.Application"
$ie.navigate("<app url>")
$doc = $ie.Document
$doc.getElementByID("<some id>")

You may read here for more information - http://msdn.microsoft.com/en-us/magazine/cc337896.aspx

Hope this helps.

answered Apr 27, 2012 at 20:37

Angshuman Agarwal

4,8768 gold badges45 silver badges92 bronze badges

Collectives™ on Stack Overflow

extract values from td tags in Powershell

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related