Challenge #20: List Parsing

[RichoBsJ]

Hi! Here my solution :)

[sachin02]

My solution : 

[T_Willins]

This took some time to tease out all the iterations of how data is presented.  My workflow has a discrepancy for record #1252.  After reviewing the data and looking at the presentation of the fax number for this company, it looks like the number at the end of the address is actually the phone number and not part of the address.  I could have added to my last formula tool to remove this result and put it back on the address, but my results are correct as is and I am leaving the discrepancy.  If I was creating this for production, I would have completed the data cleanse and made the phone/fax numbers in standard format.

Spoiler

[ChrisMelck]

That was a more challenging challenge for me

[nini]

My Solution:

[nikolaskardasis]

Spoiler

[ponraj]

Here is my solution!

[kelly_gilbert]

Didn't quite get the address parsing perfect, but got really close... Regex-a-palooza!

Spoiler

[joshuaburkhow]

I think the big learning on this one is the Phone number parsing!

[AndyQ]

Found this one challenging! My take on it ...