I am currently working (in ArcMap 10.4) with two datasets that use different nomenclature for their assessor parcel numbers (APN) values. In one dataset the APN is a string dataset with the format "12345678". In the other dataset the APN is again a string but displayed as "123-456-78".
My goal is to add '-' characters to the correct position within the first string, to allow me to perform a join between the two APN fields respectively. Currently my script within the code block is seen below. I have created a new field titled "APN" and am hoping to populate this new field using the PRCL_ID string.
I am still not confident with scripting within the field calculator tool and have based this code on a similar problem in another thread. Does anyone have any suggestions on the best way to approach this problem?