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

Need to extract numbers from a field in attribute table

EGardner7

I have two fields that contain addresses that I am trying to compare by making sure just the numbers match because the addresses in one of those fields are not standardized. I already have one field that contains the numbers for the addresses that are standardized so now I am trying to create a field for numbers for the non-standardized addresses. I need to extract the numbers from the other field so I can find the ones that do not match. I am trying to use this script:

int(''.join([i for i in !YourFieldName! if i.isdigit()]))

But I get an error processing popup. I am new to using python so I was hoping someone might be able to point me in the right direction. Thanks!

Find more posts tagged with

Accepted answers

All comments

EGardner7

Hey Cody I got a different error message this time. Screenshot 2024-08-22 144903.png

CodyPatterson

Hey @EGardner7

It may be how you are returning the function, I believe you are trying to return an integer, is the AncillaryRole field an integer field? If it is not, you may try changing the datatype to be a string or similar using the string function str(), you may not even need to use str() as it could be returning as a string already:

def extract_numbers(field):
    numbers = ''.join([i for i in field if i.isdigit()])
    return str(numbers) if numbers else None

extract_numbers(!YourFieldName!)

Cody

EGardner7

T Gateway error.png Hi Cody thanks for your response. Here is the error message.

CodyPatterson

Hey @EGardner7

Could you attach a picture of the error? It may be because something is null or does not show up correctly.

You could also try placing a function in the code block and calling it for your attribute selection:

def extract_numbers(field):
    numbers = ''.join([i for i in field if i.isdigit()])
    return int(numbers) if numbers else None

extract_numbers(!YourFieldName!)

This would return None if numbers is not present.

Cody

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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