Ans:
searchStr="Test"
intRows=dataTable.GetSheet(1).GetRowCount
intCols=DataTable.GetSheet(1).GetParameterCount
intCount=0
For i= 1 to intRows
DataTable.SetCurrentRow i
For j=1 to intCols
If Trim(Datatable.Value(j,1))=searchStr then
intCount=intCount+1
end if
Next
Next
msgbox "search string found these many times" & intCount
Follow @TestingQ
searchStr="Test"
intRows=dataTable.GetSheet(1).GetRowCount
intCols=DataTable.GetSheet(1).GetParameterCount
intCount=0
For i= 1 to intRows
DataTable.SetCurrentRow i
For j=1 to intCols
If Trim(Datatable.Value(j,1))=searchStr then
intCount=intCount+1
end if
Next
Next
msgbox "search string found these many times" & intCount