How to Use Regular Expressions (REGEX) in Tableau

Описание: 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!


Connect with us:
•Book an Office Hour with Eric: https://www.eventbrite.com/e/tableau-...
•Upcoming Tableau Classes: https://www.eventbrite.com/o/onenumbe...
•Tableau Passport Program: https://onenumber.biz/tableau-trainin...
•Subscribe to the OneNumber Newsletter: https://onenumber.biz/newsletter
•Follow Eric on LinkedIn:   / eric-parker-37513249  


Resources:
•Example Tableau Workbook: https://public.tableau.com/app/profil...
•Flerlage Twins Regular Expressions Post: https://www.flerlagetwins.com/2021/05...