Help with Python Code/Field Calculator

BETAGIS

Hi. I have a String Type field in a large attribute table. I want to add a "-0" a the end of each entry or "-1", "-2", etc. See examples below:

Example entries in this case would be:

CROOKED ST 1

CROOKED ST 2

CROOKED ST 3

CROOKED ST 4

CROOKED ST 5

CROOKED ST 6

CROOKED ST 7

CROOKED ST 8

CROOKED ST 9

CROOKED ST 10

 

How can I add the '-0' to the end of each entry so it'd look like:

 

CROOKED ST-01

CROOKED ST-02

CROOKED ST-03

CROOKED ST-04

CROOKED ST-05

CROOKED ST-06

CROOKED ST-07

CROOKED ST-08

CROOKED ST-09

CROOKED ST-10

 

Anyone know if this is possible? Even if I cant change the double digit values proceeding after the 10th entry it would be a great help.

 

Thanks!

AllenDailey1

Hello,

Here is a function / code block I wrote that does what you're describing:

def number_streets(street):
    components = street.split(" ")
    num = components[-1]
    if len(num) == 1:
        num = "-0" + num
    else:
        num = "-" + num
    stname = " ".join(components[:-1])
    result = stname + num
    return result

If you want to test it out, here's an example of how I tested it:

sts = ["MY ST 1", "MY ST 2", "MY ST 10", "MY ST 41"]
for st in sts:
    print(number_streets(st))

The results I got were:

MY ST-01
MY ST-02
MY ST-10
MY ST-41

For a field calculation, the expression would be:

number_streets(!YOUR_FIELD_NAME!)

I'd be interested to hear if you use this and/or if it works for your purposes.