August Meeting - Regular Expressions Part One

Mark Hutchinson starts off a two part series on how to use Regular Expressions in Office applications. Part one will be a beginner walk through on what Regular Expressions are and the basics of their use. Regular Expressions are one of the most efficient and powerful tools for parsing large amounts of data. Their use can be found in almost all programming languages. Understanding how they work and when to use them will greatly enhance your programming versatility.

Presentation Outline:

What we used to do: a brief history VB statements Classic Basic
VB6 enhancements (found in VBA environments)

Pattern-matching Uses and Applications String Searching Algorithms Text Searching engines What to do? (what are our choices) Regex/RegExp = Regular Expressions Introduction Testing for pattern matches
Parsing text
Examples galore
Advanced topics
Handy tools and tutorials