0. Regular Expressions 2 (4:46)
How To Extract Emails and Validate Dates With Regular Expressions in Microsoft Access
Regular expressions course overview and prerequisites
1. RegEx Part 6 (27:09)
Extract Email Addresses from Text, Remove Duplicates, and Use Scripting.Dictionary
Regular expression cheat sheet review
Email address regular expression patterns
Extracting emails from messy text
Creating a reusable email extraction function
Using Scripting.Dictionary for unique emails
Late binding versus early binding dictionaries
Improving an email regex pattern
Looking up regex patterns from a table
2. RegEx Part 7 (11:38)
Remove Extra Spaces and Tabs from Imported Data Using RegEx and VBA
Cleaning imported text with regular expressions
Using \s+ to match whitespace characters
Preserving line breaks while removing spaces and tabs
Using [ \t]+ to match spaces and tabs
Creating a RegExCleanWhitespace VBA function
Previewing cleaned data in an Access query
Using Trim to remove leading and trailing spaces
Converting a preview query to an update query
Keeping original imported data in a staging table
3. RegEx Part 8 (46:49)
Extract and Validate Dates in Different Formats with RegEx and VBA
Regex patterns for ISO date formats
Regex patterns for numeric dates with slashes or hyphens
Regex patterns for written month dates
Combining Regex date patterns with OR
Using word boundaries to avoid partial date matches
Extracting date candidates with VBA
Splitting extracted dates into an array
Parsing ISO, US, and UK numeric dates
Handling two-digit years
Converting month names to month numbers
Validating dates with DateSerial
Detecting invalid dates such as February 30
Debugging a VBA loop with LBound and UBound
4. What's Next (3:06)
Regular Expressions 2, Extract Emails, Clean Imported Text, and Validate Dates
Extracting email addresses with regular expressions
Removing duplicate values with Scripting.Dictionary
Cleaning messy imported text with regular expressions
Recognizing dates in multiple formats
Validating and converting imported date values
