Scripting Blog

A place to learn about PowerShell and share stories of automation

arrays hash tables and dictionary objects - Scripting Blog

Speed Up Array Comparisons in Powershell with a Runtime Regex

February 18, 2011 Feb 18, 2011 02/18/11
ScriptingGuy1
Summary: Learn how to speed up array comparisons in Windows PowerShell by using a runtime regular expression   Hey, Scripting Guy! I am interested in speeding up comparisons of arrays when I use Windows PowerShell. Can you help me? —CR Hello CR, Microsoft Scripting Guy, Ed Wilson, here. We are still in our Guest Blogger Week, so ...

Hey, Scripting Guy! How Can I Parse My Firewall Log File to See What Kind of Packets Are Being Sent?

April 16, 2009 Apr 16, 2009 04/16/09
ScriptingGuy1
Hey, Scripting Guy! I would like to parse the firewall log on my computer and find out the kinds of packets that are going out. You know, how many Web page packets, how many DNS lookups, how many pings. That kind of stuff. I figure that I can look at these logs and pick up diagnostic information. For example, if I see a bunch of DNS queries ...

Hey, Scripting Guy! How Can I Store Arrays Within Another Array?

April 18, 2008 Apr 18, 2008 04/18/08
ScriptingGuy1
Hey, Scripting Guy! I need to read in data from a text file and store each line as a separate item in an array. However, the data in each line must also be stored as an array; in other words, I need an array made up of other arrays. I tried creating a multidimensional array, but I can’t get it to work. Can you help?-- PA Hey, PA. As you ...

Hey, Scripting Guy! How Can I Import a Fixed-Width Data File into Microsoft Excel?

April 15, 2008 Apr 15, 2008 04/15/08
ScriptingGuy1
Hey, Scripting Guy! How can I import a fixed-width data file into Microsoft Excel?-- RS Hey, RS. This column is being written on a Friday morning, and so far it’s been a very weird morning at that. For one thing, it’s not raining and – if you look closely – you can even see the sun. (It’s been awhile, but we’d recognize the sun ...

Hey, Scripting Guy! How Can I Remove Duplicate Values From a Pair of Text Files?

December 14, 2007 Dec 14, 2007 12/14/07
ScriptingGuy1
Hey, Scripting Guy! I have two text files that contain numbers. I need to write a script that can determine whether a given number exists in both of these text files. If it does, I need to delete that line from each of the two files. How do I do that?-- KT Hey, KT. Before we get started today, we have a little business to take care of. ...