Regular Expressions

Idea

Regular Expression are a sophisticated way of finding string patterns within strings.

Getting started

Prepare a table with the data where you want to find the patterns.
In the example below we have a list of names incl. salutation. We want to remove the salutations.

Create the Statement that should be found

This statement looks for all Mr, Mrs, and Ms (each with "." and without) and Miss

Replace the found Strings

Result

Help

Additional help on Regular Expression can be found in the internet:
http://msdn.microsoft.com/en-us/library/hs600312(v=vs.110).aspx
http://msdn.microsoft.com/en-us/library/system.text.regularexpressions.regex(v=vs.110).aspx