AnsweredAssumed Answered

Calculation to filter out words after ":" or "-"

Question asked by m.bodily.consulting on May 8, 2012
Latest reply on May 8, 2012 by TomHays

Hello,

I am an amateur when it comes to formulating calcualtions. Mostly through trial and error do I get things right. So I was wondering if someone knows how to do this faster than I do. Here is what I'm trying to do:

I need a calculation to search in the Title field for ":" and "-" and if the field has either character I need all words that follow it to be excluded.

Example: (Title field) William Teller: A short story >> (calculation output) William Teller

Outcomes