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:

       

      =IFERROR(VALUE(MID(AF2,FIND("(",AF2)+1,FIND(")",AF2)-FIND("(",AF2)-1)),G2)

       

      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.