Find text inside text file with script and output

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.
heliontechAsked:
Who is Participating?
 
RobSampsonConnect With a Mentor Commented:
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
 
heliontechAuthor Commented:
Handy and quick to boot ! Thank you so much.
0
 
RobSampsonCommented:
No problem. Thanks for the grade.

Regards,

Rob.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.