Sounds like the idea is to find a regex expression that works on the regexTester
and then translate it into the format that Tableau prefers.
I think there may be some format differences between what works on the testsite
and what works in Tableau.
For the example of the phone number with (area code), you could try:
a calculated field of:
REGEXP_EXTRACT([Data String], '(\(\d+\) \d+-\d+)')
Where the escape character \ is used to signify the open and close parentheses
and the \d+ signifies one or more digits.
252614regex.twbx 6.6 KB
Just what I needed. That and a couple lessons in regex syntax!