Challenge #54: Data Prep Address Parsing

[Maskell_Rascal]

Here is my solution!

Spoiler

Cheers!

Phil

[Vanzeup7]

Solution attached. Thanks,

[Steph_Maddrell]

Spoiler

[Erin]

Spoiler

First, I looked up common street suffix per USPS and pulled the state abbreviations from USPS as well (count 52 as it includes D.C. and Puerto Rico). Using some find/replace tools, I edited the Address Text to include needed commas. I also included a field for Street. 

[arpit_tyagi]

Regex, Find and replace tool, and  join helped in this. 

[vbrown]

My solution.

[youngk313]

Solution using RegEx and removing state and zip from Address Text.

[Shelbey]

Spoiler

[DaisyJones]

Managed to wiggle it down to two regex tools

Spoiler