A place to learn about PowerShell and share stories of automation
May 31, 2007May 31, 200705/31/07Hey, Scripting Guy! I have a script that starts two applications; however, the second application can not start until the first program has finished running. How can I ensure that my second program doesn’t start until the first one ends?— OR
Hey,
May 30, 2007May 30, 200705/30/07Hey, Scripting Guy! How can I delete the first line and the last line in a text file?— TF
Hey, TF. We don’t know if anyone has ever noticed, but Hey, Scripting Guy! tends to meander from time-to-time; there are those occasions when it seemingly takes forever for us to get around to answering the question of the day.
May 29, 2007May 29, 200705/29/07Hey, Scripting Guy! In an Excel spreadsheet, how can I change the color of a row if there is a date stored a particular cell in that row?— GL
Hey, GL. Some of you might have noticed that there was no Hey,
May 25, 2007May 25, 200705/25/07Hey, Scripting Guy! How can I put a button in an HTA that, when clicked, exports an HTML table to Excel?— DW
Hey, DW. You know, yesterday afternoon the Scripting Guy who writes this column went to get his hair cut,
May 24, 2007May 24, 200705/24/07Hey, Scripting Guy! I have two separate text files. One file contains a list of MAC addresses taken from a network scan; the other contains a list of MAC addresses for our currently-managed devices. How can I compare these two files,
May 23, 2007May 23, 200705/23/07Hey, Scripting Guy! A few days ago you showed us how to open a bunch of text files and save the data in each file as a record in a database. I have a similar question, except that I want to save each paragraph in a Word document as a database record.
May 22, 2007May 22, 200705/22/07Hey, Scripting Guy! We have a third-party application that rarely crashes; however, when it does crash it seriously disrupts our business. We can always tell when the application is getting ready to crash; at that point, one of its directories starts filling up with log files.
May 21, 2007May 21, 200705/21/07Hey, Scripting Guy! I have a folder that has hundreds of text files in it. I’d like to take each of those files and add the contents (as a memo field) to an Access database. How can I do that?— KB
Hey,
May 18, 2007May 18, 200705/18/07Hey, Scripting Guy! In yesterday’s column you showed us how to search for phone numbers in a text file; you also promised us that in today’s column you’d show us how to modify that script so that it can search through all the text files in a folder.
May 17, 2007May 17, 200705/17/07Hey, Scripting Guy! I have a bunch of text files, one for each of our employees. Included in these text files are phone numbers: work phone, home phone, cell phone, etc. How can I write a script that searches for and extracts the phone numbers from these text files?—
