3 Replies Latest reply on Apr 26, 2017 12:25 PM by beverly

    Removing last part of a word

    kschjei

      I have a field that has data and I would like to create a new field that shows only the words before the dash. Is there a calculation I can write that will do this? Below are examples of the text:

      Oakville-GRC

      Mary M. Knight-MC

      Irvine-PC

      A. West-GCP

       

      Thanks for any help!