1.How to find in which row or column,string "Hyderabad"
exist in excel sheet?
2.How to find how many times character "a" repeated in a
given string "Koteswararao"

Answer Posted / srividya

msgbox(len("Koteswararao")-len(Replace("Koteswararao","a","")))

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain in brief about the qtp automation object model (aom).

565


How can we extract data like "Details","Result","Time" from the 'Run Error' result generated in QTP after run time errors are generated during a run & import the details etc...into excel sheet

1538


can any body clearly explain about keyword driven framework .give me the explanation for files what ever you use in this frame work?

1692


I have written a code to fetch values fro access db and place in the fields. Iam using GetROProperty to fetch runtime values. Now i want to add runtime values to the access db in field v3. please help me. Its not writting in the db. Option explicit Dim con,rs,db,c Set con=createobject("adodb.connection") Set rs=createobject("adodb.recordset") con.Open "Driver={Microsoft Access Driver (*.mdb)};dbq=D:\Sales.mdb" rs.open "select * from tax",con Do while not rs.eof Browser("Sales Tax Calculator").Page("Sales Tax Calculator").WebEdit("incost").Set rs.fields("v1") Browser("Sales Tax Calculator").Page("Sales Tax Calculator").WebEdit("intax").Set rs.fields("v2") c=Browser("Sales Tax Calculator").Page("Sales Tax Calculator").WebEdit("outtax").GetROProperty("value") rs.MoveNext print c Loop Do while not rs.EOF rs.EditMode rs.Fields("v3").Value="3" rs.Update rs.MoveNext Loop Set rs=nothing Set con=nothing

1485


Write a script to verify font style and color of a windows object using descriptive programming

837






If we put all properties in mandatory and assistive list of Normal Identification, Do we still need Smart?

577


What are the common defects found in your project? (in qtp interview)

1619


what is meant by Implicit and explicit requirements?

3623


how can i pass a "automation script" as a parameter in a function give me need full suggestion thank inadvance

1430


How do you compare the structure of 2 tables in database and check whether they are similar using qtp.

1478


Where to use function or action?

669


I created 3 actions in test suppose I want to run action 1 in single time, action 2 is 4 time what I do?

599


what are all the fileds present in object repository?

1565


How to creating an output value using quicktest professional (qtp)?

568


I hav installed QTP8.2, im working on webapplication, while running the script giving error msg like "QTPro.exe generated errors and will be closed by windows. You will restart the program. An error log is being created". Pls anybody what is the problem, what i have to do for this? Thanks...

1721