Easy Data Transform allows the use of regular expressions in the Compare, Extract, Filter, If, Replace, Slice, Split Col and Split Rows transforms. It is also available as part of the Javascript language in the Javascript transform.
Regular expressions are a powerful way to match patterns in text (including text representation of dates and numbers). For example, you can use a regular expression in the Replace transform to swap first and last names:
Turns:
Into:
Regular expressions are far too big a topic to cover here. However there are many detailed resources online, such as www.regular-expressions.info and regexr.com.