Showing results for May 2007 - Page 2 of 5 - Scripting Blog [archived]

May 23, 2007
0
0

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

ScriptingGuy1
ScriptingGuy1

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 Hey, HY. Before we tackle today’s question we know a lot of you are con...

Scripting Guy!VBScriptOffice
May 22, 2007
0
0

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

ScriptingGuy1
ScriptingGuy1

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 in this folder...

Scripting Guy!VBScriptstorage
May 21, 2007
0
0

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

ScriptingGuy1
ScriptingGuy1

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 Hey, KB. You know, a few years ago the Scripting Guy who writes this column gave a talk at a conference in Orlando. (And yes, he’ll be back in Orland...

Scripting Guy!scripting techniquesVBScript
May 18, 2007
0
0

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

ScriptingGuy1
ScriptingGuy1

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 Hey, SE. Yes, we’re going to – wait a second. SE? Interestin...

Scripting Guy!scripting techniquesVBScript
May 17, 2007
0
0

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

ScriptingGuy1
ScriptingGuy1

Hey, 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?-- MN Hey, MN. You know, many years ago the Scripting Guy who writes this column ...

Scripting Guy!scripting techniquesVBScript