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