Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Capture data between [BRACKETS]
#2
Solved: 10 Years, 7 Months, 3 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


Messages In This Thread
Capture data between [BRACKETS] - by nayak - 02-18-2012, 02:20 AM
RE: Capture data between [BRACKETS] - by inborntester - 02-18-2012, 08:36 AM
RE: Capture data between [BRACKETS] - by Ankur - 02-18-2012, 01:38 PM
RE: Capture data between [BRACKETS] - by nayak - 02-21-2012, 08:56 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Capture data from pdf rahul1234 1 3,316 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,227 03-10-2008, 04:55 PM
Last Post: test71

Forum Jump:


Users browsing this thread: 1 Guest(s)