topic Separate Numbers from Text in ArcGIS Pro Questions

Separate Numbers from Text

ChrisMacNeillNCFPD — Wed, 08 May 2024 21:40:09 GMT

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?

Re: Separate Numbers from Text

DanPatterson — Wed, 08 May 2024 21:48:32 GMT

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

Re: Separate Numbers from Text

ChrisMacNeillNCFPD — Wed, 08 May 2024 22:00:51 GMT

Awesome, thank you!

Re: Separate Numbers from Text

ChrisMacNeillNCFPD — Wed, 08 May 2024 22:21:03 GMT

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

Re: Separate Numbers from Text

DanPatterson — Thu, 09 May 2024 07:26:20 GMT

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

Re: Separate Numbers from Text

JasonBagwell1 — Thu, 09 May 2024 13:36:21 GMT

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.

Re: Separate Numbers from Text

DanPatterson — Thu, 09 May 2024 18:38:38 GMT

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

15775a

Re: Separate Numbers from Text

MeKohler — Thu, 19 Mar 2026 22:21:02 GMT

How would you start this from the right side?

Thanks.