Regex Parse

[Cscott8]

Hi everyone, 

looking for some help parsing the following expression:

Ft Smith - 114 (Rollup)
Fresno - 167 (Rollup)
Atlanta (Rollup)
Columbus-Starkville - 134 (Rollup)
Salt Lake City - 232 (Rollup)

Essentially, I want just the cities, but they come in all forms. 

Appreciate any help on this!

[jdunkerley79 · Accepted solution]

Looking at your example data I think:

^(.*?[A-Za-z])[^A-Za-z]+\(Rollup\)$

Should match the city into $1

So either using a Regex tool for formula tool can pull it out