topic Re: Isdigit code for addresses in Addressing Questions

Isdigit code for addresses

EmmanuelJohn1 — Mon, 07 Aug 2017 18:15:38 GMT

Hello everyone,

What would be the field calculator script code to only extract the numbers and nothing else from the fieldname column to hnum column?

Re: Isdigit code for addresses

DanPatterson_Retired — Sun, 12 Dec 2021 09:23:25 GMT

a = '12ab34cd5'
b = int("".join([i for i in a if i.isnumeric()]))
# in field calculator
# python parser of course
int("".join([i for i in !YourFieldNameHere! if i.isnumeric()]))‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Isdigit code for addresses

JoeBorgione — Mon, 07 Aug 2017 19:16:28 GMT

Here is a thread I started some time ago: https://community.esri.com/thread/163731 It might give some insight to using Python to parse out address components.

Something I noticed in your sample data and it's quite common with address data, and that is the lack of consistency. Your third record has no house number; I realize it's probably a dummy record but those kinds of inconsistencies need to be handled or your parser will error out once it hits a line like that. So either make sure your data is clean, or trap errors in your script.

Re: Isdigit code for addresses

EmmanuelJohn1 — Tue, 08 Aug 2017 12:24:23 GMT

Joe ,

Yes, you are correct. There can also be other values that are completely blank which can cause further issues. But for what i was trying to do it was helpful to get an idea for where to start.

Dan's code was helpful for the start, which helped me make labels from Label Expression Window instead of having to maintain a new field. This was mainly for Home Number Label service.

int("".join((i for i in [YourField] if i.isnumeric())))

This expression neglects all the blank values, and the fields without the numbers in them.

Re: Isdigit code for addresses

EmmanuelJohn1 — Tue, 08 Aug 2017 12:24:48 GMT

Thankyou Dan

Re: Isdigit code for addresses

DanPatterson_Retired — Tue, 08 Aug 2017 14:28:44 GMT

no problem Emmanuel