I have a dataset that contains a unique identifier, and a .dbf file that I need to join to my shapefile. This is the only field that I can do a join on.
The .dbf field is a 8-digit unique number, but the matching field in my shapefile has extra data both in front of and behind a number of rows. When I run the join, it understandably comes up blank as none of the rows match exactly.
If the problem was reversed, I would just strip the extra data from the .dbf file.
Is there a way I can do that in ArcMap 10.0?