Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stripping a string 2 get value within brackets?? 1

Status
Not open for further replies.
ftpdoo

ftpdoo

Programmer
Aug 9, 2001
202
GB
Hi,

I've got a string which contains contains a persons Chistian name and then their Surname in brackets.

ie: Joe (Bloggs)

How would I extract the surname within the backets just to return "Bloggs"??

Thankx,
Jonathan
 
Sort by date Sort by votes
MyName = "Joe (Bloggs)"
Lbracket = INStr(MyName, "(")
Rbracket = INStr(MyName, ")")
SurName = Mid(MyName, LBracket + 1, Rbracket - Lbracket - 1)
? SurName
Bloggs
MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question
Getting results from a dynamic dimension array
Replies
2
Views
283
Andrzejek
Andrzejek
sal21
  • Question
scrping in listbox in a web page
Replies
0
Views
210
sal21
sal21
Andrzejek
  • Locked
  • Question
Get sub-folders from FTP 1
Replies
4
Views
169
Andrzejek
Andrzejek
feipezi
  • Locked
  • Question
How to find a string from multiple Word files, which are listed on an Excel spreadsheet? 3
Replies
17
Views
386
Andrzejek
Andrzejek
remeng
  • Locked
  • Helpful tip
Microsoft Office 365 Word Macro Causing a Project is unviewable error
Replies
1
Views
323
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top