AnsweredAssumed Answered

Splitting string at "," multiple addresses

Question asked by lbenitez07 on Jul 21, 2020
Latest reply on Jul 21, 2020 by

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"


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!