Very simple question - string parsing

[n00bie]

http://chat.yahoo.com/?room=salam ::1600000002
http://chat.yahoo.com/?room=tanre::1600000002
http://chat.yahoo.com/?room=texas38room::59000542

how can you msgbox the data between ?room= and ::?

for example, the msgboxes would contain "salam ", "yanre" and "texas38room"

but.. the data between ?room= and :: can be anything, including charachters like ":"...

how can i msgbox the data in the middle?

[mattkinser]

url = Mid$(url, InStr(1, url, "room=") + 5, Len(Right$(url, InStr(1, url, ":"))))
MsgBox url

That should do it.

[n00bie]

is it possible to use "::" in the code?

: is kinda dangerous as it can be in the data

[macai]

'Place this in a module:
Public Function Between(Text As String, Delim1 As String, Delim2 As String, Optional Start As Long = 1) As String
 Dim Z, X, Y, W
 Z = InStr(Start, Text, Delim1)
 X = InStr(Start, Text, Delim2)
 If X > Z And Start <= Z Then
  Y = Z + Len(Delim1)
  W = X - Z - Len(Delim1)
  Between = Mid$(Text, Y, W)
 End If
End Function

'Usage
Msgbox Between(SomeString, "?room=", "::", 1)

I wrote this ages ago, but i just pulled it out for you.