Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 188
  • Last Modified:

search for a string in an array

I have an array of strings
now I want to search  the array for a specific string or a part of a string. I just want to know where in the array the string is.

thanks in advance
0
n96radsb
Asked:
n96radsb
1 Solution
 
JR2003Commented:
Private Sub Command1_Click()
    Dim i As Long
    Dim MyArray As Variant
    MyArray = Array("asd", "qwe", "xyz", "asd", "dfgxyzasd")
    For i = LBound(MyArray) To UBound(MyArray)
        If InStr(MyArray(i), "xyz") > 0 Then
            MsgBox "Element " & i & " contains the string"
        End If
    Next i
End Sub

0
 
rajaloysiousCommented:
     Dim listItems(4) As String
      Dim searchstr As String
      Dim bFound As Boolean
     
      searchstr = "Fou"
      Dim anItem As Variant
      listItems = Array("One", "Two", _
         "Three", "Four", "Five")
      List1.Clear
      bFound = False
      For Each anItem In listItems
         If InStr(1, anItem, searchstr) Then
            bFound = True
            Exit For
         End If
         bFound = False
      Next
    If bFound Then
        MsgBox "Found"
    Else
        MsgBox " Not found"
    End If
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now