Left & right

[Kendel]

Hi All:

How do I seperate the left & right of the string? My string looks like this:

<%Str1, Str2%>

I don't know the lenght of Str1 or Str2.

Thanks.

 

[rjoubert]

YourString = "<%Str1, Str2%>"

strLeft = Left(YourString, InStr(1, YourString, ",", 1) - 1)
strRight = Mid(YourString, InStr(1, YourString, ",", 1) + 1, Len(YourString))

 

[Sheco]

You could also use the Split() function to create an array from the string, with the comma as the delimitter.

That is probably overkill for just 2 values but for 3 or more it is a good idea.

 

[Kendel]

Thank you guys. Both solutions work for me but I'm uisng rjoubert's. Thanks again.