kschjei

Removing last part of a word

Discussion created by kschjei on Apr 26, 2017
Latest reply on Apr 26, 2017 by beverly

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!

Outcomes