Challenge #54: Data Prep Address Parsing

[Junya_Wang]

For this one, I did take a peek of the solution. 

[Kakuffo]

I went the long way around

Gonna Retry on Regex

[Sidey1978]

Here's my solution 🙂

[ctmckay18]

Very roundabout way of achieving the desired result.  

[phottovy]

More challenging than I was expecting but I used some hints from other solutions to get to my final answer.

[Ivyin702]

Please find the attached solution file.

[AmeliaG]

Spoiler

[Nezrin]

Getting comfortable with RegEx

The "Circle |Street ....." was completely new for me. @MarqueeCrew 

Anyone able to try the Parse Address tool - not able to find the CASS dataset. Not sure if that requires a special spatial license though.