This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Here's my solution! I know that I did not rename the "Address Text" to "City", but I wanted to use only one tool.
@Marcel_GavrilaUsing one formula tool with multiple formulas that is quite a feat. Nice.
Interesting challenge. Reused the text input provided in the solution, but otherwise most of the steps done through the formula tool instead of regex.
Used Delimiter text to columns to isolate string after Street references
Used REGEX to extract state
Then used count and substring formulas using the above derived data to extract city names