nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Script Find and Replace

JoshSaad1

After I export my data to a shapefile, I have a range of addresses for which I need to replace their suffixes from Dr to Ave. I'm using a process I developed in Model Builder to perform the export. Is there a way to script the edit, and integrate it into my process model? Thanks.

Vind meer berichten getagd met

Accepted answers

RichardFairhurst

After I export my data to a shapefile, I have a range of addresses for which I need to replace their suffixes from Dr to Ave. I'm using a process I developed in Model Builder to perform the export. Is there a way to script the edit, and integrate it into my process model? Thanks.

Use the Make Feature Layer tool on the export output. Then use the Select by Attributes tool to select the address range. Then use the Calculator Field tool. Basically the same as what you would most likely do in ArcMap. See the Data Management toolbox in the Layers and Table Views toolset for the first two toola and the Fields toolset for the Calculate Field tool.

All comments

RichardFairhurst

Thanks for your help. I was able to build the process in Model Builder and integrate it with my data export model.

Please mark the post that answered your question to close this thread and award points if a post was helpful. See the tag line of my post for guidance.

JoshSaad1

Thanks for your help. I was able to build the process in Model Builder and integrate it with my data export model.

YasarKorkmaz

This worked for me to clean up a specific field (PARCELNO) in multiple layers in a geodatabase. Specifically, the script deletes the "-" and " " in the PARCELNO field and replaces with nothing so that I get a PARCELNO field without spaces and "-". Since I had other fields in the layers I had to specify the field name to clear "-" and " " from.

import arcpy
import os
import string
import re
arcpy.env.workspace = r'C:\Workspace\PARCELIDCLEANUP.gdb'
fcs = arcpy.ListFeatureClasses()
# Create list of fields for keeping
 
s = ['PARCELNO']
for fc in fcs:
    print "** Now working on "+fc
    fields = arcpy.ListFields(fc)
    for field in fields:
        if field.baseName in s:
            rows = arcpy.UpdateCursor(fc)
            for row in rows:
                targetRow = row.PARCELNO
                row.PARCELNO = targetRow.replace(' ','')
                row.PARCELNO = targetRow.replace('-','')
                rows.updateRow(row)
            del row
            del rows
            print "   Parcelno cleaned"
        if not field.baseName in s:
            None
print "PARCELNO is edited"

RichardFairhurst

After I export my data to a shapefile, I have a range of addresses for which I need to replace their suffixes from Dr to Ave. I'm using a process I developed in Model Builder to perform the export. Is there a way to script the edit, and integrate it into my process model? Thanks.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.