Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » FileSystemObject   (RSS)

Hey, Scripting Guy! Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (02/20/09)

How Do I Determine the Versions of Several Executable Files Not Registered in the Registry? Hey, Scripting Guy! I need your help. I need to know the version of several executable files not registered in the registry. I can find the version of a single

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

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?

Hey, Scripting Guy! How Can I Replace Text That Includes Double Quote Marks and a Tab Character?

Hey, Scripting Guy! I read one of your columns on replacing text in a file and I found it very useful. However, I have a somewhat more-complicated need: I want to replace text that includes both double quote marks and a tab character. How can I do that?

How Can I Copy Selected Columns From a CSV File to an Excel File?

Hey, Scripting Guy! How can I copy selected columns from a CSV file to an Excel file? -- MdP Hey, MdP. One thing that people always worry about (and rightly so) is that one of these days the Scripting Guys will do something that tears a hole in the space-time

How Can I Convert a Tilde-Delimited File to Microsoft Excel Format?

Hey, Scripting Guy! How can I convert a tilde-delimited file to Microsoft Excel format? -- JN Hey, JN. You know, to tell you the truth we’re beginning to rethink our approach to this column. After all, usually we tell people how easy things are, and how

How Can I Extract Information Located Between Two Known Values in a Text File?

Hey, Scripting Guy! In a text file, how can I extract the information that appears between the string HOSTNAME= and a blank space? -- B Hey, B. You’ll have to pardon us if we seem a little sluggish today; we’re still recovering from all the fun and excitement

How Can I Clear the Contents of Any File Dropped on My Script Icon?

Hey, Scripting Guy! How can I write a script that will clear the contents of any file that I drag and drop on the script icon? -- SN Hey, SN. Say, you didn’t by any chance misplace a few hundred thousand insects did you? OK; just thought we’d ask. This

How Can I Remove Double Double Quotes From a Text File?

Hey, Scripting Guy! I have a comma-separated values file that has data similar to this: data1",""data2"","data3",""data4"". As you can see, some of the items are enclosed by two sets of double quote marks (like ""data2""). How can I remove one of those

How Can I Move the Oldest File in a Folder to a Different Folder?

Hey, Scripting Guy! How can I move the oldest file in the folder C:\Upload to C:\Download? -- DD Hey, DD. Funny you should mention the word “oldest.” The Scripting Guy who writes this column recently attended a family reunion and, for the first time ever,

How Can I Get a Script to Delete Itself?

Hey, Scripting Guy! I have a script for installing a printer that I give to my end users. When the script finishes, I’d like it to be able to delete itself. How can I get a script to delete itself? -- EA Hey, EA. You know, that’s an interesting idea:

How Can I Remove Blank Spaces Before and After a String Value?

Hey, Scripting Guy! We have a custom in-house application that writes data to a log file. The problem is that the data often has a bunch of blank spaces before and after it. How can I remove all the blank spaces that come before and after my data? --

How Can I Print Just the Text Area of an HTA?

Hey, Scripting Guy! I have an HTA where information gets written to a text area. How can I print just the information found in that text area? -- DS Hey, DS. We want you to level with us here: are the Scripting Guys dead? We ask that because we saw the

How Can I Open a Text File as Unicode?

Hey, Scripting Guy! I have some text files that include Unicode characters. When I try to open those files using a script all I get back is gibberish. How can I open a text file as Unicode? -- FA Hey, FA. You know, the truly great magicians don’t concoct

How Can I Count the Number of Words in a Text File?

Hey, Scripting Guy! How can I count the number of words in a text file? -- LA Hey, LA. You know, this is one of those questions where the Scripting Guys outsmarted themselves. (Not that outsmarting the Scripting Guys is particularly hard to do, mind you.)

How Can I Read Just the Last Line of a Text file?

Hey, Scripting Guy! How can I read just the last line of a text file? -- BM Hey, BM. You know, if you’ve ever wondered how Hey, Scripting Guy! differs from other daily columns (like, say, Dear Abby ), well, here’s one way. Suppose someone writes Dear
More Posts Next page »
 
Page view tracker