Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Capture data between [BRACKETS]
#1
Solved: 10 Years, 7 Months, 2 Weeks ago
Dear QTP/VBscript experts:
Here is what I am not able to do. Please help me.

1. capture specific data located in a WebElement data string
2. the WebElement has data like this ---> I am in [London] for 1 week
I need to capture London from the data string in the WebElement. Basically I want to capture data between the brackets []
3. Hold this in a variable and compare input parameter with output data which is the data between the brackets.
4. I need to use an IF THEN ELSE IF statement to compare the two variables and show what was captured in the result.

I tried to capture from WebTable but the brackets are a part of the data like [London] so I still cannot compare.
Expected data is London but actual is showing as [London]
I am not sure how to isolate this data from the rest of the data.
Please help.
Thanks.

Reply
#2
Solved: 10 Years, 7 Months, 2 Weeks ago
i am bit not clear with what data u get either whole "I am in [London] for 1 week" or "[London]"

anyway try below to remove brackets and get data. and do if for compare, bit easy only.
Case1:

Code:
data ="I am in [London] for 1 week"
startpos=inStr(data ,"[")
endpos =inStrRev(data,"]")
required=mid(data,startpos+1,(endpos-startpos-1))
msgbox(required)

Case2:
Code:
data="[London]"
required=mid(data,2,(Len(data)-2))
msgbox(required)
Reply
#3
Solved: 10 Years, 7 Months, 2 Weeks ago
@inborntester - Thanks for your contribution here. Could you please make sure to keep your code snippets under code tags? You can use 'Preview post' button and then select code tag from the tool bar. I am doing it for you this time.
Want to fast track your QTP/UFT Learning? Join our UFT Training Course
Reply
#4
Solved: 10 Years, 7 Months, 2 Weeks ago At 
Here is one more logic
Code:
data ="I am in [London] for 1 week"
a=split(data,"[")
b=Trim(Split(a(1),"]"))

msgbox b(0) 'London
Reply
#5
Solved: 10 Years, 7 Months, 2 Weeks ago
@inborntester - I tried Case1 Code. Its working as I wanted. Thank you very much!
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Capture data from pdf rahul1234 1 3,314 02-23-2010, 02:26 PM
Last Post: Sivakumar Munganda
  How to rerieve data from .xls & compare with data in data table test71 6 6,223 03-10-2008, 04:55 PM
Last Post: test71

Forum Jump:


Users browsing this thread: 1 Guest(s)