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

Splitting string at "," multiple addresses

LABenitez

I got table field from the county and I just want to extract city from the addresses provided, I don't have any python background.

sample table field situs_addr:

123 street name, city state zip

45 street and street, city state zip

1000 street blvd, city name state zip

I successfully got the address number with street name separated using "split"

!<SPAN>s</SPAN><SPAN>itus_addr</SPAN>!<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>split<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN><SPAN class="" style="color: #669900; border: 0px; font-weight: inherit;">','</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">)</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">[</SPAN><SPAN class="" style="color: #990000; border: 0px; font-weight: inherit;">0</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">]</SPAN>

but I'm having a hard time figuring out how to extract just the city, since the length of each addresses are different.

Thank you!

Untitled.png

Encuentra más publicaciones etiquetadas con

Accepted answers

DavidPike

AS the city could be more than 1 word I might suggest splitting by a space, then takin the last but 2 entries:

<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" "</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN>!situs_addr!<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>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" "</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

All comments

LABenitez

(" ".join(( !Situs_Addr! .split(',')[1]).split(" "))[:-9])

I just selected the one with addresses and this code works!

Thank you so much!

LABenitez

DavidPike

Could you 'Check the Geoprocessing results window' for more details?

LABenitez

!Situs_Addr!.split(',')[1].split(' ')[0]

LABenitez

Same, it didn't work.

LABenitez

Situs_Addr.split(',')[1].split(' ')[0]

It didn't work.

DavidPike

AS the city could be more than 1 word I might suggest splitting by a space, then takin the last but 2 entries:

<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" "</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN>!situs_addr!<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>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" "</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

DonShawEsri

Lets say you have a variable called address

address = '123 street name, city state zip'

You are correctly splitting the string on the comma. When you do that, you get this


['123 street name', 'city state zip']

This gives you two items in a list. You want to grab the second item (index 1), and split again... but this time splitting on spaces. You will then grab the city on index 0 (state = index 1, zip = index 2).

address.split(', ')[1].split(' ')[0]

The result is the city

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.