Using MID function with Workbench 3?
I need to extract the "Pushing or Pulling" expression from the string below:
Strain or Injury By: Pushing or Pulling
When I try to use the MID function, I know how to identify the text and the starting location, but I'm having trouble expressing how to dynamically capture the rest of the text following the colon. If I express an actual number, it triggers an error for any fields that don't have that many characters following the colon. If I leave the expression blank,
I appreciate any help!