View Full Version : [SLEEPER:] Regular Expressions in Excel and Access
Lammutaja
05-25-2005, 06:00 AM
Hello.
Where can i find good materials about using regular expressions in Excel
and Access?
What books can be suggested for beginner/proffessional in this area?
I have book "Mastering Regular Expressions" (http://www.oreilly.com/catalog/regex/index.html), but
this is mostly for Perl programming.
J?ri.
Zack Barresse
06-15-2005, 04:43 PM
Hi there J?ri (nice name!),
A great source ...
http://www.vbaexpress.com/kb/getarticle.php?kb_id=68
Here are some other links ...
http://www.regular-expressions.info/tutorial.html
http://www.grigsoft.com/wincmp3/help/sources/html/cmp_dialog_regexpressions.htm
http://www.dslimited.biz/support/ultrasleuth/advancedsearch/advancedsearch_regex.html
http://www.regexbuddy.com/
http://www.regexlib.com/Default.aspx
http://workshops.fedstats.gov/Brown/tabletalk.html
http://weblogs.asp.net/rosherove/archive/2004/05/01/124266.aspx
http://www.aivosto.com/regexpr.html
brettdj
06-15-2005, 04:57 PM
Hi Juri,
My take is that there are 3 steps to conquer or at least get a working knowledge of RegExp
1) Master the techniques in Excel to use the Execute, Test and Replace methods for vbscript regular expressions. Learn how to use submatches etc. Hopefully my example file that Zack linked to helps you with this
2) Brush up on your pattern skills from O'Reillys book, websites such as the above, pattern testers etc. It doesn't matter too much if you learn from Perl, with some exceptions like lookahead functionality the patterns are interchangeable with vbscript. I picked up my understanding from a Perl help forum.
3) Practice, practice, practice
Cheers
Dave
Lammutaja
06-15-2005, 10:35 PM
Thanks! :thumb
Emily
11-15-2006, 03:23 AM
Regular Expression Laboratory is an assistant simple to use tool to help you learn and prepare regular expressions.
http://www.silveragesoftware.com/rxl.html
The Python Regular Expression Debugger
http://kodos.sourceforge.net/
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.