Replace part of string in multiple fields of multiple SHPs

PanGIS

Hi,

I am working with ArcMap, if needed I can install PRO on the machine.

I have a folder with multiple SHP.

I have to modify part of the string  in multiple fields and for all my SHPs.  THE SAME replacement across all my fields and SHPs.

Tried already code block in single SHP, Model builder and python....all failed.

 

according to the example below: how do I change ALL "https" into "http" for both SHPs?

thanks!

JoshuaBixby

If you have tried code and it failed, it helps to share what you tried and the error message with traceback.  That way, people can make specific comments on what you tried.

In terms of the actual 'https' to 'http' replacement, that can be easily achieved using a Python string replacement:

<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> url <SPAN class="operator token">=</SPAN> "https<SPAN class="punctuation token">:</SPAN><SPAN class="operator token">//</SPAN>resources<SPAN class="punctuation token">.</SPAN>arcgis<SPAN class="punctuation token">.</SPAN>com<SPAN class="operator token">/</SPAN>en<SPAN class="operator token">/</SPAN>help<SPAN class="operator token">/</SPAN>main<SPAN class="operator token">/</SPAN><SPAN class="number token">10.2</SPAN><SPAN class="operator token">/</SPAN>index<SPAN class="punctuation token">.</SPAN>html<SPAN class="comment token">#//018w00000011000000"</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> new_url <SPAN class="operator token">=</SPAN> url<SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'https:'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'http:'</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> new_url
'http<SPAN class="punctuation token">:</SPAN><SPAN class="operator token">//</SPAN>resources<SPAN class="punctuation token">.</SPAN>arcgis<SPAN class="punctuation token">.</SPAN>com<SPAN class="operator token">/</SPAN>en<SPAN class="operator token">/</SPAN>help<SPAN class="operator token">/</SPAN>main<SPAN class="operator token">/</SPAN><SPAN class="number token">10.2</SPAN><SPAN class="operator token">/</SPAN>index<SPAN class="punctuation token">.</SPAN>html<SPAN class="comment token">#//018w00000011000000'</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Next, embed that code in an update cursor:

<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> da

table <SPAN class="operator token">=</SPAN> <SPAN class="comment token"># path to shape file</SPAN>
fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Link1"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Link2"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Link3"</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="keyword token">with</SPAN> da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>table<SPAN class="punctuation token">,</SPAN> fields<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
        row <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>s<SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'https:'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'http:'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">for</SPAN> s <SPAN class="keyword token">in</SPAN> row<SPAN class="punctuation token">]</SPAN>
        cursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>