AnsweredAssumed Answered

Splitting string at "," multiple addresses

Question asked by lbenitez07 on Jul 21, 2020
Latest reply on Jul 21, 2020 by Davepike101@hotmail.com

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!

Attachments

Outcomes