Results 1 to 3 of 3

Thread: Selecting text containing fragments

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Mar 2000
    Location
    Davis, CA
    Posts
    23
    Does anyone know how to select a word that would contain a set of characters?

    e.g. select the entire http://www.vb-world.net because the word has 'http' in it, and then store it into a variable(I want to view source and find a link out of it in a web page).

  2. #2

    Thread Starter
    Junior Member
    Join Date
    Mar 2000
    Location
    Davis, CA
    Posts
    23
    I found this code but have no clue as to how to use it.
    Code:
    mySearchString = "ABC"
    Set myResultSet = myCon.OpenResultSet("Select myField From myTable Where UPPER(myField) Like UPPER('%" & mySearchString & "%')")
    Any suggestions? I want it to search the variable 'src' and just give me the first on it finds.

    [Edited by sp007 on 05-15-2000 at 10:32 PM]

  3. #3
    Hyperactive Member
    Join Date
    Jul 2002
    Location
    Canada
    Posts
    455
    Hello sp007,

    a Little bit help for your first question.

    Private Sub Text1_DblClick()
    If Len(Text1.Text) <> Text1.SelStart + Text1.SelLength Then
    MsgBox Mid(Text1.Text, Str(Text1.SelStart + 1), Str(Text1.SelLength - 1))
    Else
    MsgBox Mid(Text1.Text, Str(Text1.SelStart + 1))
    End If
    End Sub


    Michelle.

    [Edited by michelle on 05-16-2000 at 05:37 AM]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width