I would like to clean up fields that contain repeated "Street Names". As seen below, I have fields "Name_From" and "Name_To". These fields sometimes repeat the same name (highlighted). I would like to remove these repeated street names.
As seen below in the Name_From field, the highlighted record says "Preller & Preller". I would like to end with only "Preller". ("Preller & Preller" becomes only "Preller".)
This repetition is also present in the Name_To field.