ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

Text File Search

Updated on August 6, 2016

Text File Search

Applications often report on their status by writing to log files. These log files contain a wealth of information and can be used by system administrators to determine the health of a computing system. Searching these log files manually would take hours, if not days. VBScript offers the Scripting.FileSystemObject, which can be used to perform a programmatic text file search for certain string. For example, if an administrator runs across a text file which contains 5000 lines of text and she wants to search for the term “failed”, it would take her quite some time to find that term if it even exists. It may exist in the log file several times as well. If she were to write a script as shown below using VBScript, this process can go from taking hours to minutes or seconds, vastly improving her productivity.

VBScript Code

Search Text File Code
Search Text File Code | Source

Text File

Text File
Text File | Source

Create a Text File to Search

Setup a simple test file first. Open Notepad by going to Start-->All Programs-->Accessories-->Notepad. Within Notepad, go to File-->Save As and save the file to C:\Temp\textfile.txt. In the newly created text file, type “test1”, then press “enter”, “test2”, press “enter”, “test3”, press “enter” and on to “test 5”. The file should look like the picture on the right. Save this file by going to File-->Save. Close the textfile.txt file. This file will be used as the file to be searched by the VBScript that will be created below.

Create VBScript

Open Notepad by going to Start-->All Program-->Accessories-->Notepad. Within Notepad, go to File-->Save As and save the file to C:\Temp\ searchTxtFile.vbs. Adding the “.vbs” file extension makes the text file a VBScript executable. Copy the following code into the searchTxtFile.vbs file. Within the code, there are comments, which start with “’”. These comments explain what the code is doing.

Start copy on line below.

Option Explicit

'Define the location of the text file to read and set it to a variable named txttoread.

Const txttoread = "C:\temp\textfile.txt"

'Declare Variables

Public objFSO

Public wshShell

Public objReadFile

Dim strLine

Dim count

'Set Objects

Set objFSO = CreateObject("Scripting.FileSystemObject")

Set wshShell = CreateObject( "WScript.Shell" )

'Opens text file to read only.

Set objReadFile = objFSO.OpenTextFile(txttoread, 1, False)

'The count variable will be used to count the number of times the "test3" string is found.

'It will be set to "0" initially.

count = 0

'Loops through each line until it reaches the end of the text file.

Do Until objReadFile.AtEndOfStream

strLine = objReadFile.ReadLine

'If "test3" is found in the text file, count will no longer = "0"

'and a message will appear.

If instr(strLine, "test3") Then

count = count + 1

End If

Loop

'Display message to user on the number of times "test3" was found.

If count = 0 Then

wscript.echo "test3 was not found!"

Else

wscript.echo "Number of times test3 was found: " & count

End If

'close text file

objReadFile.close

'Clean up objects from memory

Set objFSO = nothing

Set wshShell = nothing

Stop copy on line above.

VBScript Messagebox

Found test3
Found test3 | Source
test3 Not Found
test3 Not Found | Source

Run VBScript and Test the Text file Search

Test VBScript by browsing to C:\Temp\ searchTxtFile.vbs and double clicking on the searshTxtFile.vbs script. A messagebox should pop up stating that test3 was found with a number indicating how many times it was found.Browse to the C:\temp\textfile.txt file and double click on it. Delete the “test3” line and save the file. Double click on the searchTxtFile.vbs file again. A different messagebox should appear stating that test3 was not found.

Experiment with the textfile.txt by adding several more lines that include the string “test3”. Save the file and run the searchTxtFile.vbs file again. Make note of the number of times test3 is found in the messagebox that appears. Experimentation with the VBScript and text file should give the user an idea of how valuable searching a text file can be.

Comments

    0 of 8192 characters used
    Post Comment

    No comments yet.

    working

    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: https://hubpages.com/privacy-policy#gdpr

    Show Details
    Necessary
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
    Features
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Marketing
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Statistics
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)