Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

So 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 Arc? (using vrs 10, if that matters).

Thank you!!

share|improve this question
Please provide an example of the values you are trying to join. – blah238 Mar 22 '13 at 23:41

If I'm understanding you correctly, can you trim the leading/ending numbers off and then do a join? Since you can't edit the FId(I don't think so) make a new field and copy that data to it so you can then edit.

share|improve this answer
well, i can edit the field if i want to. it's a rather large dataset though, so i wanted to trim the numbers off in a batch edit of some kind. – aquavenae Mar 24 '13 at 23:27
I FIGURED IT OUT. really simple actually. did a find and replace. took me a bit to come to this conclusion on my own! – aquavenae Mar 25 '13 at 18:00

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.