topic Splitting string at "," multiple addresses in Python Questions

Splitting string at "," multiple addresses

LABenitez — Tue, 21 Jul 2020 18:30:28 GMT

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"

!situs_addr!.split(',')[0]

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!

Re: Splitting string at "," multiple addresses

DonShawEsri — Sun, 12 Dec 2021 08:06:43 GMT

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

Re: Splitting string at "," multiple addresses

DavidPike — Sun, 12 Dec 2021 08:06:46 GMT

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

(" ".join((!situs_addr!.split(',')[1]).split(" "))[:-2])
‍

Re: Splitting string at "," multiple addresses

LABenitez — Tue, 21 Jul 2020 19:39:39 GMT

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

It didn't work.

Re: Splitting string at "," multiple addresses

LABenitez — Tue, 21 Jul 2020 19:40:31 GMT

Same, it didn't work.

Re: Splitting string at "," multiple addresses

LABenitez — Tue, 21 Jul 2020 19:41:58 GMT

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

Re: Splitting string at "," multiple addresses

DavidPike — Tue, 21 Jul 2020 19:49:57 GMT

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

Re: Splitting string at "," multiple addresses

LABenitez — Tue, 21 Jul 2020 20:16:47 GMT

Re: Splitting string at "," multiple addresses

KenBuja — Tue, 21 Jul 2020 20:25:47 GMT

Are any of the records blank or missing the ","?

Re: Splitting string at "," multiple addresses

LABenitez — Tue, 21 Jul 2020 20:52:33 GMT

Yes, some rows are blank.

Re: Splitting string at "," multiple addresses

DavidPike — Tue, 21 Jul 2020 21:10:50 GMT

pre-logic window (python):

def func(string):

   #could make this better but does the job probably
    if len(string) > 0:
        result = (" ".join(((a.split(',')[1]).split(" "))[:-2]))[1:]
    else:
        result = ""

return result

code window below pre-logic window:

func(!situs_addr!)

Re: Splitting string at "," multiple addresses

LABenitez — Tue, 21 Jul 2020 22:01:40 GMT

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

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

Thank you so much!

Re: Splitting string at "," multiple addresses

JoshuaBixby — Tue, 21 Jul 2020 23:08:24 GMT

The OP didn't state (no pun intended) whether State is name or postal abbreviation. It is likely the latter, but if the former, this approach will fail on several states.

Re: Splitting string at "," multiple addresses

DavidPike — Tue, 21 Jul 2020 23:26:14 GMT

Of course! I even assured myself that all states had one word names.