A place to learn about PowerShell and share stories of automation
February 29, 2008Feb 29, 200802/29/08Hey, Scripting Guy! How can I get a list of all the users in an OU who are not a member of a specified group?
— TJ
Hey, TJ. You know, the Scripting Guys are having so much fun with the 2008 Winter Scripting Games that we just can’t bear to see the excitement come to an end;
February 28, 2008Feb 28, 200802/28/08Hey, Scripting Guy! I have tens of thousands of files that all have a file name that includes a number bounded by two underscore characters; for example, P_19_L00.jpg. I need to figure out which number is embedded in a file name,
February 27, 2008Feb 27, 200802/27/08Hey, Scripting Guy! I see that it is pretty easy to generate a GUID using Windows Script Host. But how can I do this using Windows PowerShell?
— DL
Hey, DL. Before we begin we’d like to announce that the Scripting Guys are looking for 158 volunteers,
February 26, 2008Feb 26, 200802/26/08Hey, Scripting Guy! How can I create a script that will list all the files in a directory that have a specific value in a specific cell of an Office Excel workbook? And can that be expanded into a find/replace function?
February 25, 2008Feb 25, 200802/25/08Hey, Scripting Guy! I have a bunch of reports and log files that are saved as Microsoft Word documents. I’d like to be able to search for a specific word in one of these documents (e.g., the word “Failed”) and then change the background color of any paragraph that the target word appears in.
February 22, 2008Feb 22, 200802/22/08Hey, Scripting Guy! have a folder that has a whole bunch of files in it. Many of those files have a file name that includes an incorrect date; for example, the file might be named FGA Site Visit 2-14-07 204.jpg when it should really be named FGA Site Visit 2-14-08 204.jpg.
February 21, 2008Feb 21, 200802/21/08Hey, Scripting Guy! My manager does not like appointment reminders; therefore every meeting request she sends is without reminders. I like reminders and I try to remember to turn them on, but sometimes I forget; that means that if I’m not on top of my schedule,
February 20, 2008Feb 20, 200802/20/08Hey, Scripting Guy! I’m trying to determine – and mark – the first occurrence of a number in an Office Excel worksheet. However, I can’t figure out how to go about doing this. Can you help?
— BH
Hey, BH. Before we launch into today’s column we have an announcement to make: the Scripting Guys surrender.
February 19, 2008Feb 19, 200802/19/08Hey, Scripting Guy! Here’s what I would like to do. I would like to put a script in the SendTo folder that would enable a user to easily change the file extension for a file. (Typically our users hide the file extensions,
February 18, 2008Feb 18, 200802/18/08Hey, Scripting Guy! I’m trying to use regular expressions to extract three-digit numbers that are enclosed by pipe characters; they embedded in string values like this: |159|468|572|843|. However, I can’t figure out the syntax that will get this to work. Can you help me?
