I wrote this code, that will search in a string in between an opening and closing phrase:
VB Code:
  1. Private Sub Form_Load()
  2.     MsgBox FindInStr("||", "::", "Cat alpha Pensi france catarax || alabastar cheese gato faggle :: google cheese")
  3. End Sub
  4.  
  5. Public Function FindInStr(StrOpening As String, StrClosing As String, lpString As String) As String
  6.         Dim x As Integer, y As Integer, InStrStr As String, FinalStr As String
  7.             x = InStr(lpString, StrOpening)
  8.                 x = x + Len(StrOpening)
  9.                FinalStr = Mid(lpString, x, Len(lpString) - x)
  10.                 y = InStr(FinalStr, StrClosing)
  11.                     InStrStr = FinalStr
  12.                    FinalStr = Mid(FinalStr, y, Len(FinalStr) - y + 1)
  13.                 FindInStr = Replace(InStrStr, FinalStr, vbNullString): FindInStr = Trim(FindInStr)
  14. End Function
This will return "alabastar cheese gato faggle"

This also didnt work as i wanted, i didnt want to use replace, but i guess i had to