Challenge #54: Data Prep Address Parsing

[svenk]

My Solution!

[justin_winter]

That one was actually a bit harder than I was anticipating! Took me a bit to finally key off the "Avenue", "Drive", "Street" etc part to get it working correctly!

[kelly_gilbert]

My solution involved a little more manual input than I would have liked.

Spoiler

[cmfelton]

These parsing challenges trip me up at first every. single. time.

[neilgallen]

always fun when you get regex. I have access to the address tools, but wanted to see if I could accomplish without.

[Ukashi]

Thank you for challenge never enough of Regex

Spoiler

[MattKing]

Hi Here is my solution

[danilang]

Tricky.  I spend quite some time trying to figure the logic error in my formula until i found out the IsInteger("04252") doesn't return true because of the leading "0". I finally had to use regex_match to determine if the last 5 characters of the string where indeed integers.  Seems very counter intuitive. 

Dan  

[willstom1]

Found this very tricky due to a lack of RegEx experience but got there in the end!  

Spoiler

[JDelgado]

RegEx... Grrr...