Challenge #54: Data Prep Address Parsing

[WernerE]

Thanks

[anshuverma0912]

Hi, Here is my solution

[Tony_Castillo]

Spoiler

[simbert]

Tried to not use Regex since it's a beginner's challenge but saw afterwards that the solution uses it too, so I'm not feeling too guilty.

Spoiler

[rajatsadan]

Interesting! Learnt a lot about RegEx Tool to solve this problem.

[Hamza21]

I had no idea how to use REGEX at the start so this took much longer than I'd like to admit haha

[sunny430]

My solution:

[Hamza21]

I did the solution in two ways.

1. is to spit out the requireds.

2. is to also add in a column for street address. 

Its not as automated as I'd like since it still needs me to input common street name identifiers (ST, DR, etc)

[AkimasaKajitani]

My solution.

I think that this challenge is not beginner level.

I make 2 pattern. The one is normal and another is use only regression tools.

Spoiler

[A2H]

Spoiler