Challenge #54: Data Prep Address Parsing

[fimler]

My Solution - fairly straight-forward

[Qiu]

Regex again

Spoiler

[Owaisf]

___________

[BobHabbijam]

Creating the replacement table to enable parsing was a bit of a fiddle. Need to do more of this 

[Siobhan_Purcell]

[p_padham]

Hi everyone!

It was fun to experiment with regex for this challenge!

Here is my solution:

Spoiler

[Jayfay]

Thanks.

[alishadhillon__]

[david14]

I would love to see how this task is performed on larger, dirtier data sets. I used the regex_replace function to replace the street name with pipe and followed up with a series of other formulas to extract the data of interest.

[Christoph_Ebersbach]

Nice Task. Worked with a whitelist and Append Tool.