Hello, I am trying to join a table to feature class using a field (parcel ID) that is common to both of them. However, around 700+ parcel IDs (out of 6500+) are formatted incorrectly. For example: * 51-23-0600-015-UI15 vs. 51-23-0600-015UI15 * 06-20-1798-139-EX vs. 06-20-1798-139EX I am trying to figure out how to edit these unmatched values in ArcGIS Pro so that the join proceeds. Is there a way to apply a rule - e.g. remove the 15th character (-) from the values on the left so that they match the values on the right? Thanks!

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

edit selected attributes using rules

dsinha

Hello,

I am trying to join a table to feature class using a field (parcel ID) that is common to both of them. However, around 700+ parcel IDs (out of 6500+) are formatted incorrectly. For example:

51-23-0600-015-UI15 vs. 51-23-0600-015UI15
06-20-1798-139-EX vs. 06-20-1798-139EX

I am trying to figure out how to edit these unmatched values in ArcGIS Pro so that the join proceeds. Is there a way to apply a rule - e.g. remove the 15th character (-) from the values on the left so that they match the values on the right?

Thanks!

Vind meer berichten getagd met

Desktop

Accepted answers

CodyPatterson

Hey @dsinha

That is my bad I should have attached a screenshot, it should look something like this:

Cody

All comments

dsinha

Oh, this is beautiful! I wish I had your skills @CodyPatterson! Thanks a million!

CodyPatterson

Hey @dsinha

It should look something like this, you'd just have to rebuild the string which this does:

def remove(item):
    if item and len(item) > 14:
        prefix = item[:14]
        suffix = item[14:].replace("-", "")
        return prefix + suffix
    return item

As with all code, just make sure that this is valid for your purposes and doesn't indirectly edit anything else!

Cody

dsinha

@CodyPatterson just curious - what would the expression look like if I want to remove any "-" after the 14th character?

dsinha

Thanks so much for sending the screenshot @CodyPatterson. Worked like a charm!

CodyPatterson

Hey @dsinha

That is my bad I should have attached a screenshot, it should look something like this:

Cody

dsinha

Thanks so much for your help @CodyPatterson!

I tried to run the expression but I got an error message (though the expression is valid):

CodyPatterson

Hey @dsinha

If these are incorrect, would it be possible to just fix them? If the - is always at the 15th slot, you could use a calculate field function to fix this:

def remove(item):
    if item and len(item) >= 15 and item[14] == "-":
        return item[:14] + item[15:]
    return item

I would test this on a small subset of data to ensure this does what you're expecting!

Cody

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.