I don't see a tool to find and replace text in the attribute table of ArcGIS Pro
I also have this question, can the find and replace tool be found anywhere when looking at attribute table records? Thank you
I don't think there is one. If you want to replace text, pick your attribute, click Calculate, type in the first box:
and in the "Code Block" box:
import redef replace(val): return re.sub ('OLDVALUE', 'NEWVALUE', val)
..or just stick with ArcMap.
Thank you, I think I will be going back to ArcMap. I keep trying with Pro
but they still need a bit more time. Appreciate the help.
GIS Technician I
Protected Resources Division
NOAA Fisheries West Coast Region
U.S. Department of Commerce
Contractor with Ocean Associates, Inc.
Alvaro and Stephen Smith,
I'd encourage you to please post this as an idea in the ArcGIS Ideas space. See Submitting a New Idea if you're not familiar with the process. Ideas allow the community to vote and share the ways that they use this functionality. In this case, you and others will be able to share why the Find and Replace functionality is important to your daily workflows, and why not having it in Pro is keeping you from using Pro (which sounds like the case for you).
@@esri My 2 red cents worth: So is this the new norm for re-writing the core software? We, as user, have to tell you every little feature we're missing in Pro that is in Arcmap now and we use daily, just so we can get it added back? What a way to do business. Why don't you make it work like the current version we're used to using then build on that? And you wonder why we get so frustrated at change. Way to go esri... Not happy with this way of thinking at all.
This was also the case where we lost "Spatial Join" functionality being changed from Arcview 3.x, where a spatial join could be placed using the "shape" fields of 2 feature classes without creating new output, we can no longer do! Another, is the "Select Path" in the coverage days where you could select 2 line segments and it would find the shortest path between them, where did that go? So, why do we keep losing legacy good useful tools in each new release? Please explain... Or just add 'em back.
Thank you very much!
This was very useful. It works. thank you!!!
Please go to Add basic find functionality to ArcGIS Pro table view! and up vote that Idea if this functionality is important to you!
Over the weekend I spent a considerable amount of time trying to use the code block above. Very frustrating when it doesn't work. I don't appreciate Esri forcing users to become Python scripting gurus. There is NO reason the same SIMPLE tool found in ArcMap shouldn't have been part of first release of ArcGIS Pro. Especially if they are taking Catalog away as a separate interface to work with data.
I put the script in a model, see if it works. You should be able to just pick the layer and field you want to change. Text has to be in quotation marks. Reopen the table to see the change.
Thanks for taking the time to do that! I will pull the model down and see what happens. I made changes with quotations, spaces, commas, etc. with no success over the weekend. Hopefully, this will point out what I was missing.
Here is a screenshot of my results. I'm not smart enough to cipher through the error message. However, I recognize some similar notation to my attempts with the manual input. Thoughts? Much appreciated!
Looks like the script works on a text field. I'm guessing your RDCLASS is either a Short or Long?
L R Can you verify that the script should work with integers as well as text?
The data being used was downloaded from a resource website. In checking on this, yes - the field is a Long, numeric format.
Yes it only works with text, you'd need some type casting to make it work with numbers. I'll, uh, look at it later.
I would sincerely appreciate it. This is interesting, as I'm pretty sure I've had no problems replacing numbers in ArcMap regardless of field type. (I could be wrong. Going to test to see.) But this appears to be another easy tool, gone bad in Pro.
Myth - Confirmed. This took about 30 seconds or less to accomplish in ArcMap. With the same data.
If anyone from Esri is following this conversation, I would recommend changing the status of this string. It is showing Assumed Answered. From my perspective, it's not. Thanks!
Hi Kenny and all on this thread. I saw there was some activity this morning so wanted to follow up. The update is that Add basic find functionality to ArcGIS Pro table view! is Under Consideration. Keep an eye on the status at that link which will be a better indicator of progress than this thread.
Hope this helps!
Thanks for the update and providing the link. I'll take a look and follow the activity.
Added numbers while waiting for something to get rasterized. Will probably wreck anything that isn't text (use "") or integers. Maybe I'll add float/decimals/whatever later. Incremental updates, one line at a time
You are the man, LR! Thanks for taking the time to do this. Will give it a whirl in a bit and advise results.
Advising the results of the latest version - success. It changed the long integer field with no issues. Thanks again for figuring this out!
Retrieving data ...