Is a value in an array

[Brian.Osborne]

I have a simple array I've defined.
I'm pulling a value into my datatable as a seperate action to use later.
Now I need to check my array and execute a line of code ONLY if the value I put into my datatable is present in the array.

Code:

TestArray = Array("value1", "value2")

TeWindow....TeField("FieldName").Output CheckPoint("GetValue")

If DataTable("GotValue", dtGlobalSheet) 'help me'  Then
...This code will execute if "GotValue" is in the TestArray
End If

[surya_7mar]

Code:

Function ArrayFind(arrToSearch,strToFind)
        Dim aIter
        For aIter=0 To UBound(arrToSearch)
            If Replace(Trim(arrToSearch(aIter)), chr(32), chr(160))=Replace( Trim(strToFind), chr(32), chr(160)) Then
                ArrayFind=aIter+1
                Exit Function
            End If
        Next
        ArrayFind=-1
    End Function

If ArrayFind(TestArray ,DataTable("GotValue", dtGlobalSheet)) <> -1 'help me' Then
...This code will execute if "GotValue" is in the TestArray
End If

[tarun]

Suggest you to use a collection instead of an array

[basanth27]

Worth a try.. Think about it,
Join the array using the join keyword and then use the instr function to check if the string exist.