I am working on a calculation in which I am looking for this outcome:
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.
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!