Regular Expressions are very versatile and give you a lot of power when it comes to working with string data types. Another really great point about RegEx is that it is universal, Therefore it can be used in Tableau, Alteryx, PowerBI, SQL, etc.
When looking at RegEx we can separate functions into 2 groups; Qualifiers (What) and Quantifiers (How much).
Above are the Qualifier functions for RegEx, We can see for example that if we want to include a new space we can use \s. Below is a screenshot showing that only the spaces are picked up.
If we now think about only picking up all the letters that are between a and o, We can use the following expression.
Quantifiers in RegEx are used to show how much we want to be picked up by our RegEx.
Therefore if we want to only retrieve the word RegEX from the string we do the following example.
