Split

[JackSkellington]

I have the following code

strTest= Me.arrtest(x).ToString

I need to remove part of the Me.arrtest(x).ToString that begins with a "(" that doen't always occur at the same index.

Any ideas??

 

[SgtJarrow]

Try:

strTest = Me.arrtest(x).ToString.Substring(Me.arrtest(x).IndexOf("("))

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[Qik3Coder]

given the string:

"asdfasdfasdf(asdfasdfa)asdfasdf"

are you trying to remove everything before or after? or from say "(" to ")"?

Dim strTest As New String("asdfasdfasdf(asdfasdfa)asdfasdf")
'copies everything after the (
strTest = Mid(strTest, InStr(strTest, "(") + 1)
'copies everything up to the (
strTest = Mid(strTest, 1, InStr(strTest, "(") - 1)
'copies everything except what is between ( and )
strTest = Mid(strTest, 1, InStr(strTest, "(") - 1) + Mid(strTest, InStr(strTest, ")") + 1)

-The answer to your problem may not be the answer to your question.