Showing archive results for 2008

Jun 21, 2008
Post comments count0
Post likes count0

Hey, Scripting Guy! How Can I Change the Letter Case of My File Names?

ScriptingGuy1

Hey, Scripting Guy (and the $12 million-a-year Scripting Editor)! Is there a way to mass-rename all the files in a folder, changing the letter case as needed?-- MV Hey, MV. To begin with, we should mention that we know that you actually asked two questions in your email. We’re going to deal with the first question – mass-renaming of a...

Scripting Guy!VBScriptstorage
Jun 20, 2008
Post comments count0
Post likes count0

Hey, Scripting Guy! How Can I Modify a Text File Based on the Value of a Particular Column in the File?

ScriptingGuy1

Hey, Scripting Guy! I need some help in cleaning up a text file. I have a file that contains multiple columns of data, and I need to either delete or modify lines in the file based on the value of the 13th column. Can you help me?-- AM Hey, AM. You know, usually we start off this column with some amusing (well, OK, semi-amusing) anecdote or story...

Scripting Guy!scripting techniquesVBScript
Jun 19, 2008
Post comments count0
Post likes count0

Hey, Scripting Guy! How Can I Use a File Mask When Renaming Files?

ScriptingGuy1

Hey, Scripting Guy! How can I change file names using a file mask? You know, like when you run the command-line command ren ??x???p?.* ?a????bc.x??.-- AM Hey, AM. Well, the big news out of Seattle is that the Mariners have fired their general manager, Bill Bavasi; that’s to be expected when you spend $117 million on salaries and the team yo...

Scripting Guy!scripting techniquesVBScript
Jun 18, 2008
Post comments count0
Post likes count0

Hey, Scripting Guy! How Can I Remove the Speaker Notes From a PowerPoint Presentation?

ScriptingGuy1

Hey, Scripting Guy! We have a whole bunch of PowerPoint presentations that we would like to share with other people. However, before we make these presentations available we’d like to remove all the speaker notes from each one. Is there a way we can use a script to remove the speaker notes from a PowerPoint presentation?-- TW Hey, TW. Befor...

Scripting Guy!VBScriptOffice
Jun 17, 2008
Post comments count0
Post likes count0

Hey, Scripting Guy! How Can I Remove Specified Commas from a Comma-Separated Values File?

ScriptingGuy1

Hey, Scripting Guy! I have a comma-separated values file in which several fields have a comma embedded in the field value; that’s causing problems when I try and import the information into another application. I was wondering if there is a way to remove all the commas that are enclosed inside double quote marks, leaving all the other commas in t...

Scripting Guy!scripting techniquesVBScript