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?

[DanPatterson · Accepted solution]

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