Please ensure to include your code between [code][/code] tags while asking or replying to questions.

Post Reply 
 
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5

Capture data between [BRACKETS]

02-18-2012, 08:36 AM
Post: #2
Solved: 11 Months, 3 Weeks, 2 Days, 16 Hours, 5 Minutes, 22 Seconds ago RE: Capture data between [BRACKETS]
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)
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
Capture data between [BRACKETS] - nayak - 02-18-2012, 02:20 AM
RE: Capture data between [BRACKETS] - inborntester - 02-18-2012 08:36 AM

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



User(s) browsing this thread: 1 Guest(s)