CONCATENATE PRE LOGIG THREE FIELDS ARCGIS

PintoJoão

HI PEOPLE OF GIS

I Want join Predio field and the Key field to the ID_GESSERV field. I was doing this join in excel based on the formulas, LEFT, RIGHT, MID and CONC.

I need the concatenation to always fill the "ID_PREDIO" field with 4 digits,

I think there must be a logical script for this that should be based on if> 1000 and <100 = 0 more the "ID_PREDIO" number. If> 1000 and <10 = 00 is the value of the "ID_PREDIO".

If> 1000 and <9 = 000 and the value of the "ID_PREDIO"

for example:If I receive the value 8 in the ID_PREDIO field, the concatenation will have to add 3 zeros. If you receive the value 190 the concatenation will have to add 1 zero.

Thanks a lot

danretired

a <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">11</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">111</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1111</SPAN><SPAN class="punctuation token">]</SPAN>

s <SPAN class="operator token">=</SPAN> <SPAN class="string token">"E000186"</SPAN>

e <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>

<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"{}{:>04}{}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>s<SPAN class="punctuation token">,</SPAN> i<SPAN class="punctuation token">,</SPAN>  e<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> a<SPAN class="punctuation token">]</SPAN>
Out<SPAN class="punctuation token">[</SPAN><SPAN class="number token">14</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'E00018600010'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'E00018600110'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'E00018601110'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'E00018611110'</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>

The key is the '0' padding in the middle variable, represented by 'a' above.

s is the start, e is the end values