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

Separate Numbers from Text

ChrisMacNeillNCFPD

Hey team, I have an address field with the entire address in one cell, which looks like this one for example "15775 W California AVE ". I'm trying to pull out just the number portion so I can join it to another table. The format is inconsistent and some are 3 digits and some are 5 so its giving me more trouble than I was anticipating. Anyone know of a way to do this with a calculated field?

Find more posts tagged with

Accepted answers

DanPatterson

a = "15775 W California AVE"

"".join([i for i in a.split(" ")[0] if i.isdigit])
'15775'  # for text output

int("".join([i for i in a.split(" ")[0] if i.isdigit]))
15775 # for integer output

All comments

DanPatterson

a = "15775 W California AVE"

"".join([i for i in a.split(" ")[0] if i.isdigit])
'15775'  # for text output

int("".join([i for i in a.split(" ")[0] if i.isdigit]))
15775 # for integer output

ChrisMacNeillNCFPD

Awesome, thank you!

ChrisMacNeillNCFPD

Would I replace the actual address in line 1 with the field name? So in this case a = !Address!

DanPatterson

Yes, for field calculations. In my example a would be replaced by !YourFieldName! ( !Address!, if that is the fieldname)

JasonBagwell1

Hi Chris,

I've used this Python script/calculation before with success.

!YourField!.split(' ')[0]

This separates the field at the first space, returning just the address number.

DanPatterson

split works unless the number has a letter attached like, hence the rest of the code

15775a

MeKohler

How would you start this from the right side?

Thanks.

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.