topic Re: delete duplicates records based on field in Python Questions

Re: delete duplicates records based on field

Sebastian-VlăduțCristea — Tue, 11 Apr 2023 08:37:19 GMT

Hello!

I have this repetitive "RO." and I want to delete but keep "AB, AR, AG, BC ... etc". How can I do that?

AlfredBaldenweck — Thu, 13 Apr 2023 13:49:40 GMT

Try a field calculator.

In Arcade:

Replace($feature.HASC_1, "RO.", "")

Test on one record before doing the whole table.

Anonymous User — Thu, 13 Apr 2023 13:50:37 GMT

@Sebastian-VlăduțCristeaI moved this to be its own question because that thread was posted back in 2016.

To remove the RO. you can use an update cursor:

with arcpy.da.UpdateCursor(fc, ['HASC_1']) as uCur: for row in uCur: row[0] = row[0].split('.')[-1] uCur.updateRow(row)

BlakeTerhune — Thu, 13 Apr 2023 13:52:44 GMT

Yep. Calculate Field is what you want. For variety, here's the Python equivalent.

!HASC_1!.replace("RO.", "")