PDA

View Full Version : 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/