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

    Multiple Calculations, how to separate?


      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!