I have combined values in a field that I would like to split. Field1 has values like
I need to split off everything from the hypen over and add it to field2. I'm not sure how to set the criteria to include only those records with the "-" and how to isolate and move the values to the right of the hypen.
What is the best way to go about this?