Challenge #54: Data Prep Address Parsing

[Vishnu_Sekhar]

Since my RegEx skills are below par, I reviewed other solutions to develop mine. 

[EFos]

Spoiler

[YuriTchong]

Well, this was educational.

[emjiang]

use regex

Spoiler

[DanijelDjordjic]

solution

[DanijelDjordjic]

.

[EdoardoAversaTIL]

Spoiler

 

[Harrylosborne]

Spoiler

[jon_amanrich]

Solution to challenge 54 hereafter!

Spoiler

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

[Robinvm]

Solved