By: Eric Parker
Eric Parker lives in Seattle and has been teaching Tableau and Alteryx since 2014. He's helped thousands of students solve their most pressing problems. If you have a question, feel free to reach out to him directly via email. You can follow him on LinkedIn or sign up for a Tableau Office Hour to work with him directly!
Regular Expressions are a family of functions which allow you to identify patterns in text strings and perform a manipulation based on a pattern that is recognized.
REGEXP_MATCH can determine if a substring is present in a larger string and REGEXP_REPLACE can replace a list of values with a predetermined output. These are more powerful than standard functions like CONTAINS and REPLACE because they can handle multiple search criteria at once and the can match on patterns (e.g. ABC-123) rather than exact text matches.
Ready to learn how you can harness the power of Regular Expressions in Tableau? Check out this video!
Need help with Tableau? Sign up for an office hour to work with Eric! You can also check out our upcoming classes for a Tableau deep dive!
Related Resources
Want to keep learning foundational skills in Tableau? Sign up for our weekly newsletter so you never miss new blog posts, videos and events!