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!

 

-L

Outcomes