find and replace function entire geodatabase

425
2
03-19-2019 02:42 AM
Jean-PierreDejardin
New Contributor

I have a question… i need to replace a text part in all my tables in a geodatabase e.g. Apple by Orange I have +/- 50 tables with multiple fields, and I need to replace every text block by another The find and replace function in ArcMap doesn’t work Big tank you

0 Kudos
2 Replies
deleted-user-qpvAI3Fo0MKR
Occasional Contributor III

Now would be the time to learn some Python, and especially Cursors.

The pseudo code would be:

Make a list of all your tables

Make a list of all the fields in Table1

Initiate a cursor to loop through the list of fields looking for "Apple" and replacing it with "Orange"

Make a list of all the fields in Table2, etc. etc. etc.

Jean-PierreDejardin
New Contributor

Thanks for your answer

Yes i know, Phyton is something i really need to learn. 

0 Kudos