Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Capture data between [BRACKETS]
#1
Solved: 2 Years, 9 Months, 2 Weeks, 4 Days, 12 Hours, 28 Minutes, 31 Seconds 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: 2 Years, 9 Months, 2 Weeks, 4 Days, 12 Hours, 28 Minutes, 31 Seconds 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: 2 Years, 9 Months, 2 Weeks, 4 Days, 12 Hours, 28 Minutes, 31 Seconds 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.
Please ensure that you put your code between [code] tags for better formatting. It will help us to better help you. Check this help section to to know more.
Reply
#4
Solved: 2 Years, 9 Months, 2 Weeks, 4 Days, 12 Hours, 28 Minutes, 31 Seconds 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
Ramamohana Rao
Reply
#5
Solved: 2 Years, 9 Months, 2 Weeks, 4 Days, 12 Hours, 28 Minutes, 31 Seconds 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 2,154 02-23-2010, 02:26 PM
Last Post: Sivakumar Munganda
  How to rerieve data from .xls & compare with data in data table test71 6 3,129 03-10-2008, 04:55 PM
Last Post: test71



Users browsing this thread: 1 Guest(s)