?
Solved

Find text inside text file with script and output

Posted on 2008-11-06
3
Medium Priority
?
585 Views
Last Modified: 2012-05-05
I am trying to find and gather data from a text file.  I will need to do it with a script file.  Batch or VBScript.  The data in the file is below.  What I need to input is one of the ip addresses and what I need outputted is the Unique ID on the same line.   So if I pass the script 10.2.126.200 I need it to output 00-00-02-00.  Thank you !


Changed the current scope context to 10.2.126.0 scope.

===============================================================
  Reservation Address -    Unique ID                          
===============================================================

    10.2.126.200      -    00-00-02-00
    10.2.126.202      -    00-00-02-02
    10.2.126.203      -    00-00-02-03
    10.2.126.204      -    00-00-02-04
    10.2.126.205      -    00-00-02-05
    10.2.126.206      -    00-00-02-06
    10.2.126.208      -    00-00-02-08
No of ReservedIPs : 7 in the Scope : 10.2.126.0.
Command completed successfully.
0
Comment
Question by:heliontech
  • 2
3 Comments
 
LVL 65

Accepted Solution

by:
RobSampson earned 2000 total points
ID: 22901929
Hi, try this VBS code.

Regards,

Rob.
Set objFSO = CreateObject("Scripting.FileSystemObject")
Const intForReading = 1
strTextFile = "C:\Temp\Temp\Test Script\Test.txt"
strInput = InputBox("What data are you looking for?", "Data")
Set objFile = objFSO.OpenTextFile(strTextFile, intForReading, False)
strFound = ""
While Not objFile.AtEndOfStream
	strLine = objFile.ReadLine
	If InStr(strLine, strInput) > 0 Then strFound = Mid(strLine, InStrRev(strLine, " ") + 1)
Wend
objFile.Close
If strFound = "" Then
	WScript.Echo strInput & " was not found."
Else
	WScript.Echo "Data found for " & strInput & VbCrLf & strFound
End If

Open in new window

0
 

Author Closing Comment

by:heliontech
ID: 31514238
Handy and quick to boot ! Thank you so much.
0
 
LVL 65

Expert Comment

by:RobSampson
ID: 22901954
No problem. Thanks for the grade.

Regards,

Rob.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction During my participation as a VBScript contributor at Experts Exchange, one of the most common questions I come across is this: "I have a script that runs against only one computer. How can I make it run against a list of computers in …
With User Account Control (UAC) enabled in Windows 7, one needs to open an elevated Command Prompt in order to run scripts under administrative privileges. Although the elevated Command Prompt accomplishes the task, the question How to run as script…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question