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

format field

2Quiker

Trying to format a field but I am not sure how accomplish it. The trouble I am having is the making the second to last 0 a space but only if there is no alph char. WellPin field is always 10 numbers and sometimes with an alph char. Can someone help me out by showing me how to do this with updatecurosr and in a filed calculator please?

Well WPin

W1234500000 --> 12345000 0

W1234501000--> 12345010 0

W12345010S0--> 12345010S0

W12345010S1--> 12345010S1

Here what I have so far.

import arcpy

arcpy.env.overwriteOutput = True
fc = r"C:\Temp\Wells.shp"
count = 0

def maketv_cursor(fc):  
   
    rows = arcpy.SearchCursor(table,"WPin")  
    count = 0  
    for row in rows:  
        count += 1 

#print(count)
with arcpy.da.UpdateCursor(fc,['WellID','WPin']) as cursor:  
    for row in cursor: #if row[0] in (None, "", " "):
        row [1] = (row[0][1:11]) # Field Calculator!WellID! [1:11]
        cursor.updateRow(row)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Finde mehr Beiträge mit dem Tag

Accepted answers

bixb0012

If it has to be an update cursor, try:

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

fc <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Temp\Wells.shp"</SPAN>

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'WellID'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'WPin'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>  
    <SPAN class="keyword token">for</SPAN> wellid<SPAN class="punctuation token">,</SPAN> wpin <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">if</SPAN> wellid <SPAN class="operator token">not</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="punctuation token">(</SPAN>None<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">" "</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
            i<SPAN class="punctuation token">,</SPAN>j<SPAN class="punctuation token">,</SPAN>k <SPAN class="operator token">=</SPAN> wellid<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> wellid<SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> wellid<SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN>
            wpin <SPAN class="operator token">=</SPAN> <SPAN class="string token">"{}{}{}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">,</SPAN> j <SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> j<SPAN class="punctuation token">.</SPAN>isdigit<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="string token">" "</SPAN><SPAN class="punctuation token">,</SPAN> k<SPAN class="punctuation token">)</SPAN>
            cursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>wellid<SPAN class="punctuation token">,</SPAN> wpin<SPAN class="punctuation token">]</SPAN><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>‍</SPAN></SPAN>

All comments

danretired

<SPAN class="keyword token">import</SPAN> string
nums <SPAN class="operator token">=</SPAN> string<SPAN class="punctuation token">.</SPAN>digits

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">conv</SPAN><SPAN class="punctuation token">(</SPAN> WellID <SPAN class="punctuation token">,</SPAN> nums<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="string token">"""docstring"""</SPAN>
    <SPAN class="keyword token">if</SPAN> !WellID! <SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">in</SPAN> nums<SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># two space indents</SPAN>
        <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"{} {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN> !WellID! <SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> !WellID! <SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="comment token">#four spaces indents</SPAN>
    <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># two space indents</SPAN>
        <SPAN class="keyword token">return</SPAN> !WellID! <SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="comment token">#four spaces indents</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>

2Quiker

This worked, although would it be best to do just do it through Calculate field management.

2Quiker

I am getting error 000989. If and else have two indent and the return have 4 indents.

Field Calculator

import string
nums = string.digits

def conv( WellID , nums):
    """docstring"""
  if !WellID! [-2] in nums: # two space indents
    return "{} {}".format( !WellID! [1:-2], !WellID! [-1:])#four spaces indents
  else: # two space indents
    return !WellID! [1:]‍‍‍‍‍‍‍‍‍#four spaces indents<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Code Block

def conv( WellID , nums)<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

bixb0012

Randy Burton‌, good catch, I got mixed up on what the OP was after. You are correct, I have updated my code snippet. Thanks.

RandyBurton

Joshua Bixby‌ If the goal is to keep the letter and drop the zero from the next to last position, shouldn't line 9 be ("not" isdigit) ?

wpin <SPAN class="operator token">=</SPAN> <SPAN class="string token">"{}{}{}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">,</SPAN> j <SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> j<SPAN class="punctuation token">.</SPAN>isdigit<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="string token">" "</SPAN><SPAN class="punctuation token">,</SPAN> k<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

bixb0012

If it has to be an update cursor, try:

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

fc <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Temp\Wells.shp"</SPAN>

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'WellID'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'WPin'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>  
    <SPAN class="keyword token">for</SPAN> wellid<SPAN class="punctuation token">,</SPAN> wpin <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">if</SPAN> wellid <SPAN class="operator token">not</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="punctuation token">(</SPAN>None<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">" "</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
            i<SPAN class="punctuation token">,</SPAN>j<SPAN class="punctuation token">,</SPAN>k <SPAN class="operator token">=</SPAN> wellid<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> wellid<SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> wellid<SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN>
            wpin <SPAN class="operator token">=</SPAN> <SPAN class="string token">"{}{}{}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">,</SPAN> j <SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> j<SPAN class="punctuation token">.</SPAN>isdigit<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="string token">" "</SPAN><SPAN class="punctuation token">,</SPAN> k<SPAN class="punctuation token">)</SPAN>
            cursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>wellid<SPAN class="punctuation token">,</SPAN> wpin<SPAN class="punctuation token">]</SPAN><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>‍</SPAN></SPAN>

danretired

Use the Calculate Field or the just the field calculator. I see little reason to use a search cursor on this.

besides, your 'row' is my 'fld' and I use a different means of slicing that relies less on string length but more on string head/tail positions of the things to change. I am sure you will see upon closer examination

2Quiker

I am kind of lost on this one because it's not formatted with updatecusror, can you explain what's going on please?

2Quiker

I am getting error string index out of range on line 5.

Also the "_" to " " because i need the space not the underscore.

dict = {r[0]:(r[1:]) for r in arcpy.da.SearchCursor(fc,['WellID','WPin'])}

with arcpy.da.UpdateCursor(fc,['WellID','WPin']) as cursor: 
    for row in cursor:
        if row[0][10] == '0':
            #print(row[0][:9]+"_"+row[0][-1:])
            row [1] = row[0][:9]+" "+row[0][-1:]
        else:
            print(row[0])
        cursor.updateRow(row)‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

danretired

w0 <SPAN class="operator token">=</SPAN> <SPAN class="string token">"W1234500000"</SPAN>
w1 <SPAN class="operator token">=</SPAN> <SPAN class="string token">"W12345010S0"</SPAN>

<SPAN class="keyword token">import</SPAN> string
nums <SPAN class="operator token">=</SPAN> string<SPAN class="punctuation token">.</SPAN>digits

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">conv</SPAN><SPAN class="punctuation token">(</SPAN>fld<SPAN class="punctuation token">,</SPAN> nums<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="string token">"""docstring"""</SPAN>
    <SPAN class="keyword token">if</SPAN> fld<SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">in</SPAN> nums<SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"{} {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>fld<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> fld<SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">return</SPAN> fld<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN>
        

conv<SPAN class="punctuation token">(</SPAN>w0<SPAN class="punctuation token">,</SPAN> nums<SPAN class="punctuation token">)</SPAN>
<SPAN class="string token">'12345000 0'</SPAN>

conv<SPAN class="punctuation token">(</SPAN>w1<SPAN class="punctuation token">,</SPAN> nums<SPAN class="punctuation token">)</SPAN>
<SPAN class="string token">'12345010S0'</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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

RandyBurton

A quick example (using underscore for space):

rows <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'W1234500000'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
        <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'W1234501000'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
        <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'W12345010S0'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
        <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'W12345010S1'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="punctuation token">]</SPAN>

<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> rows<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">if</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">10</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="string token">'0'</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">9</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="operator token">+</SPAN><SPAN class="string token">"_"</SPAN><SPAN class="operator token">+</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

prints<SPAN class="punctuation token">:</SPAN>
W12345000_0
W12345010_0
W12345010_0
W12345010S1‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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