Capture data between [BRACKETS]

[nayak]

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.

[inborntester]

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)

[Ankur]

@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.

[kotaramamohana]

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

[nayak]

@inborntester - I tried Case1 Code. Its working as I wanted. Thank you very much!