3 Replies Latest reply on Jun 30, 2016 9:40 AM by lindseym

    Multiple Calculations, how to separate?

    lindseym

      Good Morning,

       

      I am working on a calculation in which I am looking for this outcome:

       

      Screen Shot 2016-06-30 at 8.46.47 AM.png

       

      The calculation I am using:

      RightWords ( Comments ; 1 ) + Substitute ( Comments ; "TBD" ; TextStyleAdd ("TBD" ; HighlightYellow ) )

       

       

       

      I am guessing the ( - )  in the RID-2 example is throwing things off, as the EVM example produces the right result, but I can't get it to highlight. I use the highlight calculation in other areas and it works fine, again thinking this is my inexperience with creating calculations.

       

      Worst case scenario on this specific column, I could do a conditional format for highlight TBD, but I still need the correct number populated.

       

       

      Additional information

       

      Left of the pipe will have a 2-6 characters, and possibly 1 ( - ) hyphen but no set location of the hyphen.

       

      Right of the pipe can have TBD or 5 characters 1  ( - ) hyphen, there is a potential for a ( . ) period but I can limit the use of them.

       

       

      Thank you for your input!

       

      -L