Regular Expression to click an Link

[ramkumar]

Hello Members,

Good Day. I am facing an issue while automating my application. When my form gets submitted, it will create an assignment for another user in the form of link.

The link looks like below:
Issue: IS-101687, Stage:Issue Moderator - Review Issue, Subject:Issue-024(48969)

Out of which the bold ones are dynamically changing values. I used Database output values to get all dynamically changing values. But for certain reasons I am not anle to use the value for 48969 which is nothing but Event ID.

I want to replace the last dynamically changing value to Regaular Expression.
Here is my link: (After getting values from DB, I am passing the value to Data Table and from there I am using it again.)

Code:

d=trim(DataTable("Event_Id", dtGlobalSheet))

iname=trim(DataTable("Issue", dtGlobalSheet))

a=trim(DataTable("Issue_Id", dtGlobalSheet))

alink = "Issue: "+a+", Stage:Issue Moderator - Review Issue, Subject:"+iname+"("+d+")"

DataTable("link", dtGlobalSheet)=alink

ilink=DataTable("link", dtGlobalSheet)

Browser("Browser").Page("Infocenter - MetricStream").Link("Issue: IS-100120, Stage:Issue").SetTOProperty "text", ilink

Browser("Browser").Page("Infocenter - MetricStream").Link("Issue: IS-100120, Stage:Issue").Click

I tried using RE, but ends in vain. Can any one you, help me out resolving this issue. Your help is greatly appreciated.

Thanks
Ram

[surya_7mar]

Ru using VBSciprt if so
alink = "Issue: "+a+", Stage:Issue Moderator - Review Issue, Subject:"+iname+"("+d+")" is not correct
alink = "Issue: " & a & ", Stage:Issue Moderator - Review Issue, Subject:" & iname & "(" & d & ")"