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

how can i split a string to the first space

COTA_GISAdmin

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.

Find more posts tagged with

Accepted answers

All comments

JoeBorgione

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

DanPatterson_Retired

Glad it worked out Hugo

HugoMorales

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.

HugoMorales

Thanks for your time and help.

HugoMorales

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

DanPatterson_Retired

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

a <SPAN class="operator token">=</SPAN> <SPAN class="string token">"123 Main Street South"</SPAN>

<SPAN class="comment token"># ---- partition, slice, and join</SPAN>

<SPAN class="string token">""</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>a<SPAN class="punctuation token">.</SPAN>partition<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" "</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>strip<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="string token">'Main Street South'</SPAN>

<SPAN class="comment token"># ---- split,slice, and join</SPAN>
<SPAN class="string token">""</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>a<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" "</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="string token">'MainStreetSouth'</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

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

BalajiVeera

Try this python expression

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

DanPatterson_Retired

"".join(a.partition(" ")[1:]).strip()
'second third'<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

then use the bits

DanPatterson_Retired

a <SPAN class="operator token">=</SPAN> <SPAN class="string token">"first second third"</SPAN>

a<SPAN class="punctuation token">.</SPAN>partition<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" "</SPAN><SPAN class="punctuation token">)</SPAN>
Out<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'first'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' '</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'second third'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

will get you started

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.