CONCATENATE PRE LOGIG THREE FIELDS ARCGIS

PintoJoão — Wed, 27 May 2020 13:05:49 GMT

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

Re: CONCATENATE PRE LOGIG THREE FIELDS ARCGIS

DanPatterson — Sun, 12 Dec 2021 04:08:06 GMT

a = [1, 11, 111, 1111]

s = "E000186"

e = 0

["{}{:>04}{}".format(s, i,  e) for i in a]
Out[14]: ['E00018600010', 'E00018600110', 'E00018601110', 'E00018611110']‍‍‍‍‍‍‍‍

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

s is the start, e is the end values

topic CONCATENATE PRE LOGIG THREE FIELDS ARCGIS in Python Questions

CONCATENATE PRE LOGIG THREE FIELDS ARCGIS

Re: CONCATENATE PRE LOGIG THREE FIELDS ARCGIS