topic Re: Field calculator make 4 digit numbers in Python Questions

Field calculator make 4 digit numbers

BobbySells — Mon, 08 Jul 2013 13:05:16 GMT

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.

Re: Field calculator make 4 digit numbers

BobbySells — Mon, 08 Jul 2013 14:18:21 GMT

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

Re: Field calculator make 4 digit numbers

Anonymous User — Mon, 08 Jul 2013 14:35:24 GMT

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]

Re: Field calculator make 4 digit numbers

PhillipCobb — Sat, 11 Dec 2021 16:40:27 GMT

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! )

Re: Field calculator make 4 digit numbers

StacyRendall1 — Sat, 11 Dec 2021 16:40:30 GMT

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)

Re: Field calculator make 4 digit numbers

DanPatterson_Retired — Mon, 08 Jul 2013 22:21:32 GMT

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

Re: Field calculator make 4 digit numbers

Anonymous User — Mon, 08 Jul 2013 23:46:35 GMT

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