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