Parsing Out City Name

[lbolin]

I am needing to parse out the City name. The City name is at the end of the string. I am having trouble parsing when the name is 2 and 3 digit name. 

[Qiu]

@lbolin 
Parsing City Name is always tricky.
Maybe you want to use my reply below.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-parse-data-using-RegEx-with-my-...

[Raj]

you can use formula tool as well to get the last word

Getword([Field],(Countwords([Field]))-1)

[gaoa]

Hi @lbolin 

Is it possible to add a comma delimiter around city names or export one-word vs. two-word city names separately?

Below RegEx expression works for city names with one word.

[lbolin]

This solution catches the first word it comes to in the list. It doesn't account for city names in the address.

example:

1274 Claremont Ave Ashland     output: Claremont

[Qiu]

@lbolin 
Cases like these, I dont really think there is a better solution.😐