Scrub your data expressively

Scrub your data expressively

24 December 2013

Scrub your data in VBA using Regular Expressions (RegExp).

A Regular Expression is a sequence of characters that create a pattern. The sequence could be something complicated like <([A-Z][A-Z0-9]*)\b[^>]*<(.*?) to something simple like \d.

Regular Expressions are very useful in VBA for working with many different scenarios of strings and introducing automation for transforming your data before loading to target databases for OLAP such as Essbase, Power Pivot or SSAS.