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

Field calculator make 4 digit numbers

BobbySells

I have object with a number from 1 to 1500. I need to concatenate with another field but need all numbers to be 7 digits. Field 1 is done and contains 3 numbers. I need to add the object number field but have it as xxx0001 through xxx1500.

Finde mehr Beiträge mit dem Tag

Accepted answers

Anonymous User

Try this:

Pre-logic:

def concatFields( field1, field2 ):   digits = str(field1)[-4:]   code = str(field2)   return int(code + digits)

Expression:

concatFields( !ObjectNums!, !Field1!)

I had mine set up where the "field1" parameter is the 7 digit object numbers and "field2" is your 3 digit code. This worked for me. Be sure to set the parser to Python. See attached screenshots:

[ATTACH=CONFIG]25790[/ATTACH][ATTACH=CONFIG]25791[/ATTACH]

table.png

fieldCalc.png

All comments

BobbySells

This is what I have tried but of course errors.

def strID():
IF [ObjNum]<10
then strID()="100000"& [ObjNum]
elseif [ObjNum]<100
then strID()="10000"& [ObjNum]
elseif [ObjNum]<1000
then strID()="1000"& [ObjNum]
elseif [ObjNum]<10000
then strID()="100"& [ObjNum]
end if

Anonymous User

Try this:

Pre-logic:

def concatFields( field1, field2 ):   digits = str(field1)[-4:]   code = str(field2)   return int(code + digits)

Expression:

concatFields( !ObjectNums!, !Field1!)

table.png

fieldCalc.png

PhillipCobb

This should also work. "field1" would be the Object ID and "field2" would be the 3 digit number. create a new Text field then run.

Pre-Logic Script Code:

def concat(field1, field2):
  if field1 >= 0 and field1 < 10:
    object = str("000") + str(field1)
    return str(field2) + str(object)
  if OID > 9 and field1 < 100:
    object = str("00") + str(field1)
    return str(field2) + str(object)
  if OID > 99 and field1 < 1000:
    object = str("0") + str(field1)
    return str( field2) + str(object)
  else:
    object = str(field1)
    return  str(field2) + str(object)

Field =

concat( !FID!, !digit! )

StacyRendall1

You can also use Python zero fill string operator. It adds a defined number of zeros to the start of a string. You can use it like this:

def concatFields(Field1, ObjNum):
  prefix = str(Field1)
  suffix = str(ObjNum).zfill(4)
  return int(prefix + suffix)

DanPatterson_Retired

This could be made into a field calculator expression
'''
PaddingStringsDemo.py
'''
vals = [1,10,100,1000]
for i in vals:
out = "%08.2f" % (i)
print str(out)

And this is the output...you will note it is a string representation of the number.
>>>
00001.00
00010.00
00100.00
01000.00

Anonymous User

I think I misunderstood the original question; both Dan and Stacy have provided better answers.

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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