I have a feature class with some fields that i would like to remove the numeric characters from but just the numbers and only from the fist 3 characters of the attribute i need to able to keep the # and numbers at the end. The fields look like this FireDist HighwayDist SchoolDistFireDist 699 HWY #4763 School #132710 Rural Fire690 HWY #1762 School #131720 Rural Fire693 HWY #2770 School #139NOT in First Dist696 HWY #3765 School #134 I am not sure who to use arcpy to only look at the first 3 characters and if they are numeric to strip them and to strip it from all 3 fields at once. I would be grateful for some help. Thanks.

Try something like: >> > hwy = " 699 HWY #4" >> > hwy ' 699 HWY #4' >> > print hwy . lstrip ( '0123456789.- ' ) HWY #4

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Delete numeric characters from fields

CCWeedcontrol

I have a feature class with some fields that i would like to remove the numeric characters from but just the numbers and only from the fist 3 characters of the attribute i need to able to keep the # and numbers at the end.

The fields look like this

FireDist	HighwayDist	SchoolDist
FireDist	699 HWY #4	763 School #132
710 Rural Fire	690 HWY #1	762 School #131
720 Rural Fire	693 HWY #2	770 School #139
NOT in First Dist	696 HWY #3	765 School #134

I am not sure who to use arcpy to only look at the first 3 characters and if they are numeric to strip them and to strip it from all 3 fields at once. I would be grateful for some help.

Thanks.

Find more posts tagged with

Accepted answers

RandyBurton

Try something like:

<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> hwy <SPAN class="operator token">=</SPAN> "<SPAN class="number token">699</SPAN> HWY <SPAN class="comment token">#4"</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> hwy
'<SPAN class="number token">699</SPAN> HWY <SPAN class="comment token">#4'</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="keyword token">print</SPAN> hwy<SPAN class="punctuation token">.</SPAN>lstrip<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'0123456789.- '</SPAN><SPAN class="punctuation token">)</SPAN>
HWY <SPAN class="comment token">#4</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

JoshuaBixby

In addition to using built-in string methods, there is a fairly straightforward regular expression approach:

<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="keyword token">import</SPAN> re
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> hwy <SPAN class="operator token">=</SPAN> "<SPAN class="number token">699</SPAN> HWY <SPAN class="comment token">#4"</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> pattern <SPAN class="operator token">=</SPAN> re<SPAN class="punctuation token">.</SPAN>compile<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">"[^\W\d_]"</SPAN><SPAN class="punctuation token">,</SPAN> re<SPAN class="punctuation token">.</SPAN>UNICODE<SPAN class="punctuation token">)</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> hwy<SPAN class="punctuation token">[</SPAN>pattern<SPAN class="punctuation token">.</SPAN>search<SPAN class="punctuation token">(</SPAN>hwy<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>start<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN>
'HWY <SPAN class="comment token">#4'</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>‍</SPAN></SPAN>

JoshuaBixby

Python String constants can also be used:

<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="keyword token">import</SPAN> string
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> hwy <SPAN class="operator token">=</SPAN> "<SPAN class="number token">699</SPAN> HWY <SPAN class="comment token">#4"</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> hwy
'<SPAN class="number token">699</SPAN> HWY <SPAN class="comment token">#4'</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> hwy<SPAN class="punctuation token">.</SPAN>lstrip<SPAN class="punctuation token">(</SPAN>string<SPAN class="punctuation token">.</SPAN>digits <SPAN class="operator token">+</SPAN> string<SPAN class="punctuation token">.</SPAN>punctuation <SPAN class="operator token">+</SPAN> string<SPAN class="punctuation token">.</SPAN>whitespace<SPAN class="punctuation token">)</SPAN>
'HWY <SPAN class="comment token">#4'</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>‍</SPAN><SPAN>‍</SPAN></SPAN>

RandyBurton

Try something like:

<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> hwy <SPAN class="operator token">=</SPAN> "<SPAN class="number token">699</SPAN> HWY <SPAN class="comment token">#4"</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> hwy
'<SPAN class="number token">699</SPAN> HWY <SPAN class="comment token">#4'</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="keyword token">print</SPAN> hwy<SPAN class="punctuation token">.</SPAN>lstrip<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'0123456789.- '</SPAN><SPAN class="punctuation token">)</SPAN>
HWY <SPAN class="comment token">#4</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.