0. Regular Expressions (6:09)
Build Reusable RegEx Tools for Pattern Matching, Text Extraction, Validation, and Cleanup
Regular expressions course overview
Course prerequisites and recommended preparation
1. RegEx Part 1 (36:44)
RegEx Basics, Pattern Matching, ZIP Validation, Extracting Matches, Global, and IgnoreCase
Regular expression basics in Access VBA
Searching text for digits with a VBA loop
Creating a RegExp object
Using VBScript.RegExp for older Access
Writing digit matching patterns
Testing text with the Test method
Validating five-digit ZIP code format
Using anchors and quantifiers in patterns
Extracting matches with the Execute method
Working with MatchCollection objects
Retrieving match values
Finding all matches with Global
Looping through regex matches
Matching literal text with regex
Ignoring case with IgnoreCase
2. RegEx Part 2 (25:22)
Reusable VBA RegEx Functions, Input Validation, Optional Parameters, and Extracting Multiple Matches
Regex pattern input on an Access form
Validating text and pattern input
Creating a reusable RegexTest function
Using RegExp.Test for pattern matching
Optional case-insensitive regex matching
Adding Ignore Case form controls
Creating a reusable RegexExtract function
Extracting the first regex match
Returning multiple regex matches as text
Using semicolon-separated match results
Adding a Global regex matching option
3. RegEx Part 3 (16:47)
Build a Reusable RegEx Pattern Library, Validate ZIP4 Codes, and Clean Text with RegexReplace
Creating a RegEx pattern library table
Adding saved patterns to a combo box
Loading a selected pattern into a form
Validating ZIP and ZIP+4 codes
Using optional RegEx pattern groups
Building a reusable RegExReplace function
Removing non-digit characters from phone numbers
Using Global replace for all pattern matches
4. RegEx Part 4 (16:16)
RegEx Capture Groups, Phone Number Formatting, Replacing Matches, and Rearranging Text
Regex capture groups for phone number parts
Creating groups with parentheses in regex
Using $1, $2, and $3 in replacements
Formatting phone numbers with Regex Replace
Anchoring patterns with ^ and $
Handling nonmatching phone number data
Replacing phone numbers inside longer text
Using Global to replace multiple phone numbers
Reordering captured groups in replacements
5. RegEx Part 5 (22:50)
Extract Invoice Numbers from Messy Customer Notes Using RegEx Capture Groups and SubMatches
Invoice number extraction with regular expressions
Matching invoice labels with alternatives
Using the pipe character for OR patterns
Allowing optional invoice separators
Capturing invoice labels and numbers
Retrieving regex SubMatches in VBA
Building a RegExInvoiceNumbers VBA function
Looking up regex patterns from a table
Returning multiple invoice numbers as a list
6. What's Next (9:45)
Regular Expressions Review Patterns Text Extraction and Replacement in Microsoft Access
Course wrap-up and preview of possible future Microsoft Access developer topics.
