Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAuse regex
.
Solution to challenge 54 hereafter!
2 Regex parse to get State : (\d+)\s(.*)\s([A-Z][A-Z]) and Zip Code: .*\s(\d+)
Select to remove unwanted fields
2 more regex parse to get the city: .*\s(\w+) and .*\s(\w+\s\w+)
2 select recors after my regex to keep the right City names
Union of my outputs