Search Cursor - Search Entire Row?

Question

All,

This may be an obvious question but I am having a little trouble with this... I am writing a script to loop through all the feature classes in a given workspace, and I need to search all fields (or all string fields, at minimum) in each feature class based on a provided string.

Essentially, I need to do what the 'Find' command in ArcMap is supposed to do, except I need to run this automatically on hundreds or potentially thousands of feature classes.

I have been playing around with a Search Cursor to do this, but I havent been able to iterate through each field for every row of the table successfully.

I am sure I could call the 'Select by Attributes' tool in Python and re-run that tool for each field in the feature class, but that seems inefficient to me.

Has anyone done anything like this before? Am I over-thinking this one and there is a simple solution?

I am using 9.3.1 in this instance but could write it for 10 if necessary. Thanks in advance.

BenYoungs · Answer

Leigh,

That is essentially what I ended up doing, except your code looks a little cleaner. Thanks for the help!

BenYoungs · Answer

I think you need to use getValue and setValue to work with field names as variables (not sure though).

Thanks, that was part of my problem. I wasnt using the getValue, and I also was trying to use the field describe object instead of the field name specifically.

for field in fieldlist:
     fieldname = field.Name
     cell value = row.GetValue(field)

Thats what worked for me. Thanks again for the help.

LeighHolcombe · Answer

I think this is what you're looking for.  This is a simple find and replace routine that will loop through every field of every row in your shapefile/feature class and make the necessary changes.

x = the value you want to find
y = the value you want to replace it with
filename = the file you're working onrows = arcpy.UpdateCursor(filename)
fields = arcpy.ListFields(filename)
for row in rows:
    for field in fields:
        value = row.getValue(field)
        if value == x:
            row.setValue(field,y)
            rows.updateRow(row)

Hopefully, that at least gets you pointed in the right direction.