Module 0165: Using pattern matching in VBA

Tak Auyeung, Ph.D.

April 19, 2010
1 About this module
2 Examples of pattern matching
3 LIKE what?
 3.1 A character in a range
 3.2 A character in a set
 3.3 A character not in a range
 3.4 A character not in a set
 3.5 A single digit
 3.6 Any single character
 3.7 Any number of any characters
4 VBA/Access vs. Perl/Awk/Python/MySQL