Question { Cognizant, 14247 }

we have a link in a website or webtable How can we record
link in that table or site? link is not static we don't
know exact location of that link? how ? if u know pls give
reply with script also?

Answer

If we know the name of the name of that link then u guyes
can follow the below code....
In the above code how are you getting the value of j(i.e
column no). We are supposed to check each and every row &
column.
so I would like to add few lines in the above code,

rowcount=B.P.Webtable().rowcount
colCount=B.P.Webtable().columncount(rowcount)

For i=1 to rowcount
For j=1 to columncount
If B.P.Webtable().ChildItemCount(i,j,"link")<>0 then
set oLink=B.P.Webtable().ChildItem(i,j."link",o)
''oLink.(your desired operation)
y=oLink.GetRoProperty("Name")
If trim(y)= trim("Name of that link") then
oLink.Click
End If
Exit for
End If
Next
Next

Question { HP, 7346 }

how can I read text in browser and export the same into text
file?

Answer

''Take a value from application and copy it into the text
and excel file.


a=
Browser("CreationTime:=1").Page("Micclass:=page").webButton("html
id:=ctl00_contplhDynamic_imgSignIn").GetROProperty("name")

Set fo=CreateObject("scripting.FilesystemObject")

Set otext=fo.CreateTextFile ("c:\Text11.txt")

''otext.Write a

Set oExcel=CreateObject("Excel.Application")



oExcel.Visible=True

Set oWorkBook=oExcel.Workbooks.Open("c:\Test11.xls")

Set oWorkSheet=oWorkBook.Worksheets("Sheet1").cells(1,1)

oWorkSheet.value=a

Question { ADP, 16557 }

How to retrieve alpha bate from the alphanumeric string with
special character.

Answer

a="she25bh3k"

set reg=new regexp
s1="[a-z]"

reg.pattern=s1
reg.ignorecase=true
reg.global=True

set matchs=reg.execute(a)

for each match in matchs

a= match.value
''msgbox b
str=str&a

Next
msgbox str

Question { Broadridge, 7253 }

In Datatable having the data like this

S.no Name Address
1 raj hyderabad
2 suresh Mumbai
3 shyam chennai
4 dev banglore

i want to get the shyam row id & column id using scipting
i.e 3,3

Answer

a=
Browser("Creationtime:=1").page("micclass:=page").webtable("html
Id:=ctl00_contplhDynamic_ZeroChaosGrid_ctl00").GetRowWithCellText("ATT",,2)

b=Browser("Creationtime:=1").page("micclass:=page").webtable("html
Id:=ctl00_contplhDynamic_ZeroChaosGrid_ctl00").ColumnCount(a)

For i=1 to b

If
Trim(Browser("Creationtime:=1").page("micclass:=page").webtable("html
Id:=ctl00_contplhDynamic_ZeroChaosGrid_ctl00").GetCellData(a,i))=Trim("ATT")Then

msgbox "The correct row and column no" & a &" , " & i

Exit for
End If

Next

Question { 5198 }

in login module login button chage regularly(means login
button change to submit button).What is the code for it.

Answer

If name property keeps on changing then we can go with other
properties except name .You can take Html Id and use
descriptive programming as it used in the first post.