Expert Solution for 2011 Scripting Games Advanced Event 7: Use PowerShell and Regex to Get Twitter IDs from a Web Page

re: Expert Solution for 2011 Scripting Games Advanced Event 7: Use PowerShell and Regex to Get Twitter IDs from a Web Page

cseiter — Thu, 28 Apr 2011 18:46:57 GMT

Tome, thanks for the explaination. I attempted to create a custom object earlier but didn't understand what it was completely doing, but by 10 I understood it more, and your directed explaination wraps the steak in bacon(icing on the cake is too over-used). Creating custom objects is becoming a very import part of a self-imposed challenge "No GUI: PowerShell Only Day".

re: Expert Solution for 2011 Scripting Games Advanced Event 7: Use PowerShell and Regex to Get Twitter IDs from a Web Page

Robert — Wed, 27 Apr 2011 16:48:56 GMT

“The truth is, my first stab at this completed the requirements in only a few lines of code…”

I’m curious and would like to see your terse solution. I got a 233 char one-liner that solves the event’s requirements, except for the CSV, which to me is excessive.

Nice RegEx by the way, I’m also a RegEx enthusiast; mine is 42 char long.

re: Expert Solution for 2011 Scripting Games Advanced Event 7: Use PowerShell and Regex to Get Twitter IDs from a Web Page

Tome — Tue, 26 Apr 2011 21:32:00 GMT

Chris,

Looking at your entry: 2011sg.poshcode.org/1676

Your problem is working with strings instead of objects. Learn to use the following for everything - that includes output to screen, output to csv, etc. With time this will become second nature. Learning this technique is what turns a good scripter into a good PowerShell scripter.

I personally started with this template, but there are other ways to do it - actually there are more efficient ways, but this is the best one to start with in my opinion.

$objects = @()

foreach ($number in (0..100)) { #Simulating a loop you would be doing for every line or something else

$object = new-object psobject

$object |Add-member noteproperty -name column1 -value $number

$object |Add-member noteproperty -name column2 -value "blah$number"

$object |Add-member noteproperty -name column3 -value ([int]$number/10)

$objects += $object

}

#now you display with

$objects

#you turn to a csv with

$objects |convertto-csv file.csv

#you display to a grid with

$objects |out-gridview

re: Expert Solution for 2011 Scripting Games Advanced Event 7: Use PowerShell and Regex to Get Twitter IDs from a Web Page

IamMred — Tue, 26 Apr 2011 14:44:11 GMT

Thanks Klaus for added the uRL, I went back and added it to the appropriate place in the blog.

re: Expert Solution for 2011 Scripting Games Advanced Event 7: Use PowerShell and Regex to Get Twitter IDs from a Web Page

cseiter — Tue, 26 Apr 2011 13:03:53 GMT

Stupid spelling mistakes. Sorry, Klaus.

re: Expert Solution for 2011 Scripting Games Advanced Event 7: Use PowerShell and Regex to Get Twitter IDs from a Web Page

cseiter — Tue, 26 Apr 2011 13:03:18 GMT

right behind ya, klaue. On my script every time I would export my array containing the username comma twittername to a csv it would just give me the length of teh objects and not the actual values. I had to send it to a text file, import the text file as a csv, then export that back out as a csv to get it to work correctly. Would you mind expanding on where I went wrong on that part?

re: Expert Solution for 2011 Scripting Games Advanced Event 7: Use PowerShell and Regex to Get Twitter IDs from a Web Page

Klaus Schulte — Tue, 26 Apr 2011 12:02:11 GMT

Thanks Tome,

this a really advanced topic with an adequate solution!

It is at least advanced enough for me because I don't understand some aspects of it :-)

Anyway:

I saw that a try-catch-block is provided tp protect the download ... great!

I saw some regexps with named groups ... a wonderful feature!

I saw that it worked!

Though I had to comment the call to powershell out (on the first line) because the ISE did "hang" otherwise.

Well one last thing, I could do is to provide the URL to the solution here:

gallery.technet.microsoft.com/.../7e1a1991-be49-4e64-8198-3166fb6ac536

kind regards, Klaus