Challenge #54: Data Prep Address Parsing

[RWvanLeeuwen]

I wonder about the robustness of my solution and ponder at discussing the way this data field was created in the first place... Using a Google API would be an absolutely brilliant move (as was demonstrated)

Spoiler

[AnnaA]

This was my first attempt at a Weekly Challenge because a cruel SE told me it would be easy :) @JamesMA 

It was a team effort but we got there in the end.

[joshuaburkhow]

Got to use some regex!

[klyuka]

More deep Parsing by Formulas

Spoiler

Used Input Text Tool to create own data of street types.

[rachelgatto]

Solved. 

[Greg_Murray]

Solution attached

[Shaun_Rheeder]

Fun challenge and it really boots the regex skills.

Only used one formula tool so that's also a bonus.

[Etienne]

Pretty challenging!!