topic Re: No Find and Replace tool in ArcGIS Pro in ArcGIS Pro Questions

No Find and Replace tool in ArcGIS Pro

deleted-user-eL1mKkp8gJc9 — Tue, 06 Oct 2015 13:06:13 GMT

I don't see a tool to find and replace text in the attribute table of ArcGIS Pro

Re: No Find and Replace tool in ArcGIS Pro

deleted-user-ZhHMF2V6QPku — Tue, 13 Sep 2016 22:26:53 GMT

I also have this question, can the find and replace tool be found anywhere when looking at attribute table records? Thank you

Re: No Find and Replace tool in ArcGIS Pro

LR — Sat, 11 Dec 2021 17:08:56 GMT

I don't think there is one. If you want to replace text, pick your attribute, click Calculate, type in the first box:

replace(!YOURFIELDNAME!)‍

and in the "Code Block" box:

import re
def replace(val):
 return re.sub ('OLDVALUE', 'NEWVALUE', val)‍‍‍

..or just stick with ArcMap.

Re: No Find and Replace tool in ArcGIS Pro

deleted-user-ZhHMF2V6QPku — Wed, 14 Sep 2016 18:02:55 GMT

Hello,

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.

Cheers,

Alvaro

Alvaro Campomanes

GIS Technician I

Protected Resources Division

NOAA Fisheries West Coast Region

U.S. Department of Commerce

503-231-2377

alvaro.campomanes@noaa.gov <shanna.dunn@noaa.gov>

Contractor with Ocean Associates, Inc.

www.westcoast.fisheries.noaa.gov

Re: No Find and Replace tool in ArcGIS Pro

KoryKramer — Mon, 06 Mar 2017 15:22:21 GMT

Alvaro and StephenSmithAOT,

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).

Thank you!

Re: No Find and Replace tool in ArcGIS Pro

KoryKramer — Tue, 22 Jun 2021 08:31:43 GMT

Please go to https://community.esri.com/ideas/13295‌ and up vote that Idea if this functionality is important to you!

Re: No Find and Replace tool in ArcGIS Pro

ThomasGersthofer1 — Tue, 28 Mar 2017 09:06:55 GMT

This was very useful. It works. thank you!!!

Re: No Find and Replace tool in ArcGIS Pro

JakeKrall — Wed, 02 Aug 2017 19:39:11 GMT

@@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!

Re: No Find and Replace tool in ArcGIS Pro

Kenny_Ratliff — Mon, 09 Oct 2017 11:57:37 GMT

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.

Re: No Find and Replace tool in ArcGIS Pro

LR — Mon, 09 Oct 2017 15:00:55 GMT

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.

Re: No Find and Replace tool in ArcGIS Pro

Kenny_Ratliff — Mon, 09 Oct 2017 15:59:40 GMT

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.

Re: No Find and Replace tool in ArcGIS Pro

Kenny_Ratliff — Mon, 09 Oct 2017 16:15:24 GMT

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!

Re: No Find and Replace tool in ArcGIS Pro

KoryKramer — Mon, 09 Oct 2017 16:33:24 GMT

Looks like the script works on a text field. I'm guessing your RDCLASS is either a Short or Long?

raze‌ Can you verify that the script should work with integers as well as text?

Re: No Find and Replace tool in ArcGIS Pro

Kenny_Ratliff — Mon, 09 Oct 2017 18:31:37 GMT

The data being used was downloaded from a resource website. In checking on this, yes - the field is a Long, numeric format.

Re: No Find and Replace tool in ArcGIS Pro

LR — Tue, 10 Oct 2017 13:00:37 GMT

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.

Re: No Find and Replace tool in ArcGIS Pro

Kenny_Ratliff — Tue, 10 Oct 2017 13:07:00 GMT

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.

Re: No Find and Replace tool in ArcGIS Pro

Kenny_Ratliff — Tue, 10 Oct 2017 13:26:24 GMT

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!

Re: No Find and Replace tool in ArcGIS Pro

LR — Tue, 10 Oct 2017 14:04:29 GMT

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

Re: No Find and Replace tool in ArcGIS Pro

Kenny_Ratliff — Tue, 10 Oct 2017 14:10:51 GMT

You are the man, LR! Thanks for taking the time to do this. Will give it a whirl in a bit and advise results.

Re: No Find and Replace tool in ArcGIS Pro

Kenny_Ratliff — Wed, 11 Oct 2017 21:02:29 GMT

Advising the results of the latest version - success. It changed the long integer field with no issues. Thanks again for figuring this out!