I want to clean up the attribute table of a road shapefile for all the entries in the fields.
For example: As seen below I have a road feature with a "Name", Name From and Name To in the attribute list. In the selected row the name of the segment is Louis Botha.
The NameFrom also contains this segment name (Louis Botha & Unknown).
After I clean up the data I only want the following to present in the relevant fields:
Name = Louis Botha Name From = Unknown Name To = Janeke
Is there a way to remove this in both the the "name from" and "name to" fields for ALL the attributes?