7 Replies Latest reply on Apr 1, 2016 11:45 AM by Christi Kurihara

    Extract Values from Between Parenthesis?

    Christi Kurihara

      Hi all,


      I am converting an old excel dashboard to tableau but am struggling with 1 of the fields.  I am trying to draw a numerical value out of parenthesis in a name field.  In excel the formula looks like this:




      Basically I want it to search for parenthesis, if there are any, and pull back the value (not text) contained.  If there aren't parentheses then I want to pull back the value from a different field.  For example:


      Any help is greatly appreciated.  I am still new to tableau so even pointing me in the right direction would be helpful.