Could anyone help me build the regexp extract expression in tableau for the below pattern

userLbPl1 0
Viewed 14

Could anyone help me build the regexp extract expression in Tableau Desktop to extract the CP code. e.g.

  1. "ARR CP-77683v1 PRODUCT MAIA LAUNCH HCP Rep Triggered Email" should fetch "CP-77683v1"
  2. "cp67036v1 PRODUCT Day1 Email" should fetch "cp67036v1"
  3. "cpâ305017v1 -NCCN Clinical Practice Guidelines" should fetch "cpâ305017v1"
  4. "PRODUCT Amyloidosis Email (EN) - CP-210030E" should fetch "CP-210030E"
  5. "PRODUCT FL Efficacy Email (CPâ182768E) - EN" should fetch "CPâ182768E"
  6. "cp-242686v1_PRODUCT & PRODUCT Rep Triggered Email - FOLLOW UP" should fetch "cp-242686v1"
  7. "JCP project contact required" should fetch "NULL"
expression tableau-desktop regex
0 Answers
Related