Compare address fields

Question

I have a dataset of properties where the site address (Address, City, State, Zip) is contained within 1 field, while the postal address is broken into individual Address, City, State and Zip fields.

I need to identify the records where the addresses match.

danretired · Answer

Calculate Field Python examples—ArcGIS Pro | Documentation

Well the code won't work, It would get real ugly fast if you want to slice and compare multiple values from multiple slices in multiple fields to slices from one input field

As I said earlier, it would be easier if you added a new field and concatenated the values from the fields you want to replicate the full address.  Then, you can compare the two fields directly

GreggWolin · Answer

1. Where does the "Expression" go?

2. The table has a bunch of fields (I just included 2 for the illustration). Do i use the column# of the "visible" fields or of "all" fields?

danretired · Answer

Code block, python parser.

Expression :  match(!SiteAddress!, !PostalAddress!)

def match(fld0, fld1, chars=5):
    """match first `chars` in two fields"""
    if fld0[:chars] == fld1[:chars]:
        return 1
    return 0