Truncate a String in VBScript

Arielle

Okay this is a very simple question and I'm embarressed that I don't know it. I know it in C++ and such but for some reason I can't remember the syntax for VBScript. I want to truncate a string based on a character. For example...

http://www.frogs.com?place=egypt

What I want is to remove the ? and everything after it.

Replace doesn't work because I need it to do it regardless of what character it is.

Aug 23 '06 #1

Arielle

Nevermind I found it on another site just now. In case anyone else needs to know it's Left

MyString = Left(MyString,number)

So based on this the following would work.

MyString = "http://www.frogs.com?place=egypt"
number = Instr(MyString,"?") - 1

MyString = Left(Mystring,number)

MyString now equals http://www.frogs.com

Woot

Aug 23 '06 #2

niheel

Good job. In the url u forgot the forward slash after frogs.com.

Other than that the code looks good.

Aug 25 '06 #3