Search for characters in a string (VBScript)

I am trying to search for a word within a string. For example the string "This is a test string". I want to find the word "test" within this string and then remove all the text before "test". The result of the string should be "test string". How would I do this using vbscript?
LVL 1
illfusion82Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Shift-3Commented:
You can get the position of the substring using the InStr function, then get all characters from that point on by using Mid.
http://www.w3schools.com/vbscript/func_instr.asp
http://www.w3schools.com/vbscript/func_mid.asp


strOld = "This is a test string"
strToFind = "test"
 
intPos = InStr(strOld, strToFind)
strNew = Mid(strBase, intPos)

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DrunkenELFCommented:
Dear IllFusion,
Try the attached code.
Cheers!
D-ELF

MyVar = "This is a test string"
Right(MyVar ,InStr (MyVar,test))

Open in new window

0
Shift-3Commented:
Correction to mine.


strOld = "This is a test string"
strToFind = "test"
 
intPos = InStr(strOld, strToFind)
strNew = Mid(strOld, intPos)
 
WScript.Echo strNew

Open in new window

0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

DrunkenELFCommented:
Correction to mine too
MyVar = "This is a test string"
Result = Right(MyVar ,InStr (MyVar,test))
0
RobSampsonCommented:
Hi, as an addition to Shift-3's code, this will tell you whether the string was found or not as well, and also has the option of a case sensitive find.

Regards,

Rob.
strOriginalString = "This is a test string"
strStringToFind = "test"
 
boolCaseSensitive = True
 
If boolCaseSensitive = True Then
	intPos = InStr(strOriginalString, strStringToFind)
Else
	intPos = InStr(LCase(strOriginalString), LCase(strStringToFind))
End If
 
If intPos > 0 Then
	strNewString = Mid(strOriginalString, intPos)
	WScript.Echo "The new string is" & VbCrLf & strNewString
Else
	WScript.Echo strStringToFind & VbCrLf & "was not found in" & VbCrLf & strOriginalString & _
		VbCrLf & VbCrLf & "Case Sensitive: " & boolCaseSensitive
End If

Open in new window

0
illfusion82Author Commented:
Thanks shift-3 and everyone that posted a response. I tried shift-3's resolution and it worked perfectly!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.

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.