Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments
COURSE of the MONTH
10 days, 13 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
VBA Regular Expression Help
Posted on 2011-03-18
Looking for some help with VBA regular expressions. My input string is in the following format
1234567890 - JOHN DOE (123456789)
I am trying to extract "JOHN DOE" from the input string. Any help is greatly appreciated!!
1234567890 - JOHN DOE (123456789)
I am trying to extract "JOHN DOE" from the input string. Any help is greatly appreciated!!
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3
2
2- +2
9 Comments
Active today
Excellent article on regular expressions here:
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/A_1336-Using-Regular-Expressions-in-Visual-Basic-for-Applications-and-Visual-Basic-6.html
Which should fill in the blanks for you.
JimD.
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/A_1336-Using-Regular-Expressions-in-Visual-Basic-for-Applications-and-Visual-Basic-6.html
Which should fill in the blanks for you.
JimD.
Active today
BTW, if that's a fixed string in terms of format, then the Mid() function will do the trick nicely. The regular expressions are for searching strings when the format is not consistent.
If you need more details on anything, just let me know.
JimD.
If you need more details on anything, just let me know.
JimD.
Try this in the Immediate Pane - Alt+F11
myStr = "1234567890 - JOHN DOE (123456789)"
? Mid(myStr,Instr(myStr,"-")
JOHN DOE
myStr = "1234567890 - JOHN DOE (123456789)"
? Mid(myStr,Instr(myStr,"-")
JOHN DOE
Active 1 day ago
Another way to parse this is to use the Split() function, first by the hyphen character and then by the open parenthesis character.
The resulting string is trimmed of any leading/trailing spaces.
Example:
The resulting string is trimmed of any leading/trailing spaces.
Example:
myStr = "1234567890 - JOHN DOE (123456789)"
?Trim(Split(Split(myStr,"-")(1),"(")(0))
I like aikimark's much better - an elegant solution - three call to Split and Trim versus 4 calls to Mid and Instr. It should be faster.
Featured Post
Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works
The attack works by targeti…
- The Email Laundry
- Email Servers
- Cybersecurity
- Email Protocols
- Network Security
- Security, *Phishing
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to be returned:
Specify the second argument, which …
Suggested Courses
Course of the Month10 days, 13 hours left to enroll
765 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.