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; } } }

Remove Alph and special characters from string filed

2Quiker

I have a table with a field called group_code and in this field there strings like the following.

2,10,12,15H, 26P, 35$#. As you can see some have a alph and special characters and some don't. So i don't think i can use the cursor.updateRow([row[0][1:-1]]).

I need to remove all the Alph and special characters at the end of each column for the group_code field.

I have tried the following but no luck. I need this to be outside the field calculator.

table <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Temp\Default.gdb\LandVal"</SPAN>fieldValue <SPAN class="operator token">=</SPAN> <SPAN class="string token">"group_code"</SPAN>&nbsp; 
<SPAN class="comment token">#Removes alpha at the end&nbsp; for field in arcpy.ListFields(table, "group_code", "String"):</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; exp <SPAN class="operator token">=</SPAN> <SPAN class="string token">''</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>i <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> fieldValue <SPAN class="keyword token">if</SPAN> i<SPAN class="punctuation token">.</SPAN>isdigit<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
arcpy<SPAN class="punctuation token">.</SPAN>management<SPAN class="punctuation token">.</SPAN>CalculateField<SPAN class="punctuation token">(</SPAN>table<SPAN class="punctuation token">,</SPAN> field<SPAN class="punctuation token">,</SPAN> exp<SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>field<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"PYTHON"</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
arcpy<SPAN class="punctuation token">.</SPAN>conversion<SPAN class="punctuation token">.</SPAN>TableToTable<SPAN class="punctuation token">(</SPAN>table<SPAN class="punctuation token">,</SPAN> r<SPAN class="string token">"C:\Temp"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"LandVal_Test.dbf"</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Encontre mais publicações marcadas com

Accepted answers

All comments

ClintonDow1

Cursors can replace the CalculateField call to make it a bit clearer.

with arcpy.da.UpdateCursor(file, ['group_code']) as cursor:
   for row in cursor:
      s = row[0]
      row[0] = "".join([c for c in s if c.isnumeric()])
      cursor.updateRow(row)

edit: forgot the updateRow call

RandyBurton

It can also be written:

import arcpy
table = r"C:\Temp\Default.gdb\LV"
field = "group_code"
exp =&nbsp; "''.join(i for i in !group_code! if i.isdigit())"
arcpy.CalculateField_management(table,field,exp,"PYTHON_9.3")
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

DanPatterson_Retired

glad you tested it Randy...

RandyBurton

I tried the following, which seemed to work. This is outside ArcMap, but calls the CalculateField tool.

<SPAN class="keyword token">import</SPAN> arcpy
table <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Temp\Default.gdb\LV"</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>table<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"group_code"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"''.join(i for i in !group_code! if i.isdigit())"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"PYTHON_9.3"</SPAN><SPAN class="punctuation token">,</SPAN>"<SPAN class="comment token">#")‍‍‍‍‍‍</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

DanPatterson_Retired

python uses ! marks around the field... don't have arc* here so try !group_code! in place of c... c doesn't need to be a variable In fact give it whirl in the field calculator. Whatever works there will work in the calculatefield expression... that is how you test them

2Quiker

what i am working with .

#Removes alpha at the end

import string, arcpy

table = r"C:\Temp\Default.gdb\LV"
for field in arcpy.ListFields(table, "group_code", "String"):
    c = "group_code"
    exp = ''.join([i for i in c if i.isdigit()]) #''.join([i for i in c if i.isdigit()])
    arcpy.CalculateField_management(table, "group_code", exp.format(field), "PYTHON_9.3")

I am getting error .

ExecuteError: Failed to execute. Parameters are not valid.
ERROR 000735: Expression: Value is required

DanPatterson_Retired

Calculate Field—Help | ArcGIS for Desktop

Check the syntax and use Python_9.3

what did it print? (through in some print statements prior to calculate field)

did you just try to put the field name in explicitly as the expression ? ie

''.join([i for i in !FieldName! if i.isdigit()])

2Quiker

Maybe i didn't explain what i am needing correctly.

working table looks like the following.

OID	group_code
1	35$#
2	12
3	26P
4	10
5	2

From what i understand is that c = "35$#' is the character to be checked. i don't just need it to check 35$# i need it to check the whole group_code field and remove the the Alph & Special Characters from all of the attributes in the "group_code" field.

Like the following..

OID	group_code
1	35
2	12
3	26
4	10
5	2

Or maybe i am not understand how to incorporate what you two suggested in to my current script.

DanPatterson_Retired

many ways, the only difference between your line 4 and my line 2, is when the join gets done, it is sometimes just a matter of preference.

c <SPAN class="operator token">=</SPAN> "<SPAN class="number token">35</SPAN>$<SPAN class="comment token">#"</SPAN>
<SPAN class="string token">''</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>i <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> c <SPAN class="keyword token">if</SPAN> i<SPAN class="punctuation token">.</SPAN>isdigit<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="string token">"35"</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

RandyBurton

Try without the square brackets, something like:

<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> string <SPAN class="operator token">=</SPAN> "<SPAN class="number token">35</SPAN>$<SPAN class="comment token">#"</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="string token">''</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>c <SPAN class="keyword token">for</SPAN> c <SPAN class="keyword token">in</SPAN> string <SPAN class="keyword token">if</SPAN> c <SPAN class="keyword token">in</SPAN> <SPAN class="string token">'0123456789'</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="string token">'35'</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="string token">''</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>c <SPAN class="keyword token">for</SPAN> c <SPAN class="keyword token">in</SPAN> string <SPAN class="keyword token">if</SPAN> c<SPAN class="punctuation token">.</SPAN>isdigit<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="string token">'35'</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

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