Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Here's my solution! I know that I did not rename the "Address Text" to "City", but I wanted to use only one tool.
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
