topic Re: edit selected attributes using rules in ArcGIS Pro Questions

edit selected attributes using rules

dsinha — Tue, 05 Aug 2025 14:52:30 GMT

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!

Re: edit selected attributes using rules

CodyPatterson — Tue, 05 Aug 2025 15:05:02 GMT

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

Re: edit selected attributes using rules

dsinha — Tue, 05 Aug 2025 15:18:48 GMT

Thanks so much for your help @CodyPatterson!

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

Re: edit selected attributes using rules

CodyPatterson — Tue, 05 Aug 2025 15:26:49 GMT

Hey @dsinha

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

Cody

Re: edit selected attributes using rules

dsinha — Tue, 05 Aug 2025 15:30:27 GMT

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

Re: edit selected attributes using rules

dsinha — Tue, 05 Aug 2025 15:39:46 GMT

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

Re: edit selected attributes using rules

CodyPatterson — Tue, 05 Aug 2025 15:46:41 GMT

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

Re: edit selected attributes using rules

dsinha — Tue, 05 Aug 2025 16:07:55 GMT

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