AnsweredAssumed Answered

CONCATENATE PRE LOGIG THREE FIELDS ARCGIS

Question asked by JMFPESRI2020 on May 27, 2020
Latest reply on May 27, 2020 by danretired

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.

enter image description here

Thanks a lot

Outcomes