Scripting Blog [archived]

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

How Can I Save Each Paragraph in a Word Document as a Database Record?

(image) Hey, 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. How can I do that?-- HY (image) (image) (image) Hey, HY. Before we tackle today’...

How Can I Monitor the Number of Files in a Folder?

(image) Hey, 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. How can we be notified any time the number of log files ...

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

(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?

(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...