community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Regex Parse

Atom

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!

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

Labels