3 Replies Latest reply on Aug 16, 2016 5:33 AM by Mahfooj Khan

    Extract only numbers

    Aleks Roth

      1. Hello, I am newbie in tableau, I am trying to write a regular expression which returns a number which is between parentheses. Field have several lines. 

       

      Content lines:

      "Resolution(03:03): the software is installed"

      "Resolution(10:12): software removed"

      "Resolution(05:01): Software configuration"

      I want to find:

      03:03

      10:12

      05:01

      Numbers have different value,  01:01 - 01:99 and 01:01 - 99:01 and 99:01 - 99:99

       

      2. Field contains only one text:

      "Message cancel by the user"

      How can I search this text using "contains" function?