Showing results for October 2007 - Page 2 of 5 - Scripting Blog [archived]

Hey, Scripting Guy! I have a whole bunch of text files in a folder. I need to open each of these files, extract everything between the <filecount> and </filecount> tags, and then write that information to a separate file. How can I do that?-- RP Hey, RP. You know, the other day the Scripting Guy who writes this column and the Scripti...

Hey, Scripting Guy! We have a spreadsheet that includes numbers like this: 31738. However, this isn’t supposed to be a number, it’s actually supposed to be a date: 11/22/1986. How can I convert these numbers to dates and then, if needed, convert those dates back to numbers?-- TC Hey, TC. Yes, as a matter of fact it did take the Scripting Guy who...

Hey, Scripting Guy! How can I retrieve a list of unique users from the Security event log?-- KM Hey, KM. Before we tackle your question we should probably address a question sent in by another reader: Hey, Scripting Guy! Whatever happened to Monday? Having been gone on vacation all last week, I was combing through the Hey, Scripting Guy! ar...

Hey, Scripting Guy! How can I tell if a computer is Bluetooth-enabled?-- RR Hey, RR. You know, any time the Scripting Guys get asked something like this, one question immediately pops into our minds: “So where did the name Bluetooth come from anyway?” As it turns out, the Bluetooth “personal area networking” protocol was named in honor of Harald...

Hey, Scripting Guy! I have an Office Excel spreadsheet in which the last row in the spreadsheet sums all the rows above it. How can I add new rows (and new data) to this spreadsheet, making sure that the last row always sums up all the rows above it?-- AW Hey, AW. By the way, please excuse the mess; at the moment we’re sitting around waiting for...