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

How do I calculate a field using sequential numbers but maintain a defined number of digits?

JimNoble

I'd like to create a field of sequential numbers starting at 001 counting all the way until 322. Every number must be 3 digits. How do I do this?

Thank you all for your help.

Vind meer berichten getagd met

Accepted answers

JakeSkinner

Hi James,

You can do this using the Field Calculator. Here is an example:

rec<SPAN class="operator token">=</SPAN><SPAN class="number token">0</SPAN>
<SPAN class="keyword token">def</SPAN> <SPAN class="token function">autoIncrement</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
 <SPAN class="keyword token">global</SPAN> rec
 pStart <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN> <SPAN class="comment token">#adjust start value, if req'd </SPAN>
 pInterval <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN> <SPAN class="comment token">#adjust interval value, if req'd</SPAN>
 <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>rec <SPAN class="operator token">==</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN> 
  rec <SPAN class="operator token">=</SPAN> pStart 
 <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN> 
  rec <SPAN class="operator token">=</SPAN> rec <SPAN class="operator token">+</SPAN> pInterval 
 <SPAN class="keyword token">if</SPAN> len<SPAN class="punctuation token">(</SPAN>str<SPAN class="punctuation token">(</SPAN>rec<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="keyword token">return</SPAN> <SPAN class="string token">"00"</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>rec<SPAN class="punctuation token">)</SPAN>
 <SPAN class="keyword token">elif</SPAN> len<SPAN class="punctuation token">(</SPAN>str<SPAN class="punctuation token">(</SPAN>rec<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="keyword token">return</SPAN> <SPAN class="string token">"0"</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>rec<SPAN class="punctuation token">)</SPAN>
 <SPAN class="keyword token">elif</SPAN> len<SPAN class="punctuation token">(</SPAN>str<SPAN class="punctuation token">(</SPAN>rec<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">:</SPAN>
     <SPAN class="keyword token">return</SPAN> str<SPAN class="punctuation token">(</SPAN>rec<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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

JakeSkinner

Hi James,

You can do this using the Field Calculator. Here is an example:

rec<SPAN class="operator token">=</SPAN><SPAN class="number token">0</SPAN>
<SPAN class="keyword token">def</SPAN> <SPAN class="token function">autoIncrement</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
 <SPAN class="keyword token">global</SPAN> rec
 pStart <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN> <SPAN class="comment token">#adjust start value, if req'd </SPAN>
 pInterval <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN> <SPAN class="comment token">#adjust interval value, if req'd</SPAN>
 <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>rec <SPAN class="operator token">==</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN> 
  rec <SPAN class="operator token">=</SPAN> pStart 
 <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN> 
  rec <SPAN class="operator token">=</SPAN> rec <SPAN class="operator token">+</SPAN> pInterval 
 <SPAN class="keyword token">if</SPAN> len<SPAN class="punctuation token">(</SPAN>str<SPAN class="punctuation token">(</SPAN>rec<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="keyword token">return</SPAN> <SPAN class="string token">"00"</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>rec<SPAN class="punctuation token">)</SPAN>
 <SPAN class="keyword token">elif</SPAN> len<SPAN class="punctuation token">(</SPAN>str<SPAN class="punctuation token">(</SPAN>rec<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="keyword token">return</SPAN> <SPAN class="string token">"0"</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>rec<SPAN class="punctuation token">)</SPAN>
 <SPAN class="keyword token">elif</SPAN> len<SPAN class="punctuation token">(</SPAN>str<SPAN class="punctuation token">(</SPAN>rec<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">:</SPAN>
     <SPAN class="keyword token">return</SPAN> str<SPAN class="punctuation token">(</SPAN>rec<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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JimNoble

Thanks Jake. That's perfect!

JoshuaBixby

Another approach, instead of using global variables, is to use a generator:

Code Block:

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">gen</SPAN><SPAN class="punctuation token">(</SPAN>x<SPAN class="operator token">=</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">while</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">yield</SPAN> <SPAN class="string token">"{:0=3}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>x<SPAN class="punctuation token">)</SPAN>
        x<SPAN class="operator token">+=</SPAN><SPAN class="number token">1</SPAN>

g <SPAN class="operator token">=</SPAN> gen<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>

Expression:

next<SPAN class="punctuation token">(</SPAN>g<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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