Interested to Buy Any Domain ? << Click Here >> for more details...
abt filter function
if iam using below two statments its ok
My = Array ("Apples","Oranges", "Apricots")
MyResult = Filter(My, "Oran")
if i use msgbox MyResult
it shows type mismatch
plz help me
- 2 Answers
- 4696 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / lakshmi
Boss,
Filter function will a zero-based 1-D array. so we have to
use subscript.Filter function may return more than one
matches. then u have to take a loop (for or while) and u
have repeat this loop until ubound of that array.So in u r
case, please see the answer below:
My = Array ("Apples","Oranges", "Apricots")
MyResult = Filter(My, "Oran")
Msgbox MyResult(0)
Here i was mentioed subscript as 0 as we have only one item
which matcehs with u r search.
If there is more than one match, then u have to do likt
this.
My = Array ("Apples","Oranges", "Apricots")
MyResult = Filter(My, "Oran")
For i=0 ubound(MyResult)-1
Msgbox MyResult(i)
Next.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / reddy prasad
Hi
thanks lakshmi
regards
reddy prasad
raju16prasad@gmail.com
| Is This Answer Correct ? | 0 Yes | 0 No |
what is difference between wait and synchronization point.
How many ways to configure the application in QTP,Explain
What are the two types of repositories available, explain them?
What is meant by a Check Point in UFT? Also, explain the applicable Check Points.
Dim ExcelSheet Set ExcelSheet = CreateObject("Excel.Application") excelsheet.application.visible = true ExcelSheet.ActiveSheet.Cells(1,1).Value = "This is column A, row 1" ' Save the sheet. ExcelSheet.SaveAs "C:\DOCS\TEST.XLS" ' Close Excel with the Quit method on the Application object. ExcelSheet.Application.Quit after run this script i am getting error"The test cannot continue due to unrecoverable error"
How will you handle application crash using recovery scenario manager(step by step process)?
hi is there any chance to change encoding the password
HOW TO FIND WEBTABLE? HOW TO RETRIVE THE WEBTABLE VALUES? PLZ TELL ME THE PROCEDURE.
1.In VB Script 100 lines Script. How can check the Syntax errors? 2. Write a VB Script for X = India/Srilanka/Australia/England/South Africa.I need the Output Country wise? [ 1st Msgbox India , 2nd Msgbox Srilanka] ---- 3. How can Choose these test cases to be automated?
QTP script is not working on other's machine..
If there r 1000 test scripts that were written. If a change to any functionality is to be made then how can we know in which script is this functionality existing.
What does ".mst" stands for? (abc.mst)
WinRunner 
