AnsweredAssumed Answered

Multiple Calculations, how to separate?

Question asked by lindseym on Jun 30, 2016
Latest reply on Jun 30, 2016 by 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!