Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

text files - Scripting Blog [archived]

How Can I Add the Contents of a Group of Text Files to an Access Database?

May 21, 2007 May 21, 2007 05/21/07
ScriptingGuy1
(image) Hey, 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(image) (image) (image) Hey, KB. You know, a few years ago the Scripting Guy who writes this column gave a talk at a conference in ...

How Can I Search Every Text File in a Folder For Phone Numbers?

May 18, 2007 May 18, 2007 05/18/07
ScriptingGuy1
(image) Hey, 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. Are you still going to do that?-- SE(image) (image) (image) Hey, SE. Yes, we...

How Can I Replace Single Quote Marks in a Text File?

May 4, 2007 May 4, 2007 05/4/07
ScriptingGuy1
(image) Hey, Scripting Guy! I saw your column on replacing text in a text file, and that’s almost the solution I’m looking for. However, the text I need to replace is the single quote mark, and I can’t figure out how to do that. How do I replace single quote marks in a text file?-- JB(image) (image) (image) Hey, JB. You know, this is...

How Can I Replace the First Five Characters in a Text File With the First Five Characters in the Computer Name?

April 23, 2007 Apr 23, 2007 04/23/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I open a text file and replace the first 5 characters with the first 5 characters of the local computer name?-- EC(image) (image) (image) Hey, EC. You know, you might find this hard to believe (his fellow Scripting Guys absolutely refuse to believe it), but sometimes the Scripting Guy who writes this ...