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.