Latest Contributions by 2Quiker

I tried your suggestion to put it into a script but i still just get "No" for all the features. Would it have to do with the fact that the taxparcels address filed are all upper case letters and the points address field are all lower case? ... View more

Hi Mitch. thank you for the reply and help. I tried the code but i am getting the same results as before. I select the points in Arcmap and run the code in ArcMap python window. All of the point features have 'No' in the Verifi2 filed. on line 12 of your code should it be if row[1] != addDict[row[1]] since your comparing the SiteAddress and SiteAddres fields? Here is the code i am working with. import arcpy from datetime import datetime as d startTime = d.now() fc1 = "AddresPointsTest" fc2 = "TaxParcels1" #set up cursors cursor1 = arcpy.da.SearchCursor(fc1, ["SiteAddres", "Verifi2"])  cursor2 = arcpy.da.SearchCursor(fc2, ["SiteAddress"]) #build a dictionary of OBJECTID : Address pairs, change OID@ to your uniqueID #addDict is for the taxparcels addDict = {row[0]:row[1] for row in arcpy.da.SearchCursor(fc2, ['OID@','SiteAddress'])} #search through fc2 to see if addresses match based on OBJECTID value #again, change OID@ to your uniqueID #UpdateCursor is for the address points with arcpy.da.UpdateCursor(fc1, ['OID@','SiteAddres','Verifi2']) as cursor:     for row in cursor:         if row[0] in addDict:             if row[1] != addDict[row[0]]: #if the value associated with those ids do not match                 row[2] = 'No'             else:                 row[2] = 'Match'             cursor.updateRow(row) del cursor try:     print '(Elapsed time: ' + str(d.now() - startTime)[:-3] + ')' except Exception, e:     # If an error occurred, print line number and error message     import traceback, sys     tb = sys.exc_info()[2]     print "Line %i" % tb.tb_lineno     print e.message‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Yes they do have a unique ID that links them together. I guess i didn't think this through all the way...hummm So some parcels have an address point (separate layer) but some address points don't match the parcels(separate layer) site addresses i need to find the ones that match and don't match, but only of the selected features in ArcMap. ... View more

It was my pc, i restarted my pc and recreated the file geodatabase and ran the script and it did what it was suppose to do. Sorry about that and thanks for the help! ... View more

What bug are you referring to, is there a patch for this bug? any other way around this? ... View more

I am on ArcGIS 10.3.1, i am runign the script on python 2.7.8 IDLE, the table is in a file geodatabase. I have attached a portion of table i am working with. Thanks. ... View more

Joshua thanks for the replay and updated code, but when i run the code it runs fun i don't get any error's but nothing happens to the table, no records are delete. ... View more

Partly yes, thank you for post ... View more

Thanks to both of you Joshua and Mitch for sharing some code it does delete the duplicates but i need it to only keep one of the Acct with 01 in the group_code field and the highest value in the value filed. unless i am not seeing something in your code...? ... View more

Darn i just realized that that i need it to keep just one of the Acct with 01 in the group_code but the one with the highest value in the "value" field. As you can see on the attached table there might be duplicate values. ... View more

what i am working with . #Removes alpha at the end   import string, arcpy table = r"C:\Temp\Default.gdb\LV" for field in arcpy.ListFields(table, "group_code", "String"):     c = "group_code"     exp = ''.join([i for i in c if i.isdigit()]) #''.join([i for i in c if i.isdigit()])       arcpy.CalculateField_management(table, "group_code", exp.format(field), "PYTHON_9.3") I am getting error . ExecuteError: Failed to execute. Parameters are not valid. ERROR 000735: Expression: Value is required ... View more

Maybe i didn't explain what i am needing correctly. working table looks like the following. OID group_code 1 35$# 2 12 3 26P 4 10 5 2 From what i understand is that c = "35$#' is the character to be checked. i don't just need it to check 35$# i need it to check the whole group_code field and remove the the Alph & Special Characters from all of the attributes in the "group_code" field. Like the following.. OID group_code 1 35 2 12 3 26 4 10 5 2 Or maybe i am not understand how to incorporate what you two suggested in to my current script. ... View more