topic Re: how can i split a string to the first space in ArcGIS Pro Questions

how can i split a string to the first space

COTA_GISAdmin — Thu, 25 Oct 2018 19:28:21 GMT

I am trying to split an address field in arcmap using the field calculator

for example...

2387 Resource Rd. Apartment 34

and i need to get rid of of the first set of numbers (2387)

Resource Rd. Apartment 34

I try using the split / lsplit / rsplit functions but i am doing something wrong.

any ideas?

thanks for your help in advance.

Re: how can i split a string to the first space

DanPatterson_Retired — Sat, 11 Dec 2021 23:48:28 GMT

a = "first second third"

a.partition(" ")
Out[2]: ('first', ' ', 'second third')‍‍‍‍

will get you started

Re: how can i split a string to the first space

DanPatterson_Retired — Sat, 11 Dec 2021 23:48:31 GMT

"".join(a.partition(" ")[1:]).strip()
'second third'‍‍

then use the bits

Re: how can i split a string to the first space

BalajiVeera — Thu, 25 Oct 2018 20:30:28 GMT

Try this python expression

' '.join(!ADDRESS!.split(' ')[1:])

Re: how can i split a string to the first space

DanPatterson_Retired — Sat, 11 Dec 2021 23:48:33 GMT

partition will answer more questions that a simple split. It is often overlooked

a = "123 Main Street South"

# ---- partition, slice, and join

"".join(a.partition(" ")[1:]).strip()

'Main Street South'

# ---- split,slice, and join
"".join(a.split(" ")[1:])
'MainStreetSouth'‍‍‍‍‍‍‍‍‍‍‍

a = !Address! I use 'a' to represent the field

Re: how can i split a string to the first space

HugoMorales — Fri, 26 Oct 2018 12:46:59 GMT

Thanks for your help, this works perfectly for what i need

Re: how can i split a string to the first space

HugoMorales — Fri, 26 Oct 2018 12:47:51 GMT

Thanks for your time and help.

Re: how can i split a string to the first space

HugoMorales — Fri, 26 Oct 2018 13:26:49 GMT

thanks a lot ... i really appreciate your time and help... I finally figure out ... using your advice and also using others advice that reply to my question...

this was my first time submitting a question and i was wondering how it will work... i have to say its awesome.

thanks again.

Re: how can i split a string to the first space

DanPatterson_Retired — Fri, 26 Oct 2018 13:39:34 GMT

Glad it worked out Hugo

Re: how can i split a string to the first space

JoeBorgione — Fri, 26 Oct 2018 14:06:35 GMT

A little late in the game but here's a thread I started a couple years back and still refer back to:

https://community.esri.com/thread/163731