Challenge #20: List Parsing

[Jim7]

Quite a few tricks in the original data set to keep your regex honest :) Attached is my solution.

[justin_winter]

Ugh, that was one of the uglier ones. Pretty trial and error solution that still isn't perfect...

[dillon_bok]

Spoiler

[Kenda]

Spoiler

What a mess! I ran and reran the workflow so many times to account for each of the variations in the data. Ended up using a lot of RegEx in my formulas.

[CHarrison]

Finding the difference between Address & Company name was a challenge, but got there in the end :) 

[aking]

Pretty tedious

Spoiler

[OldDogNewTricks]

I have got to say this was a pain and took me about 3 different iterations.  However, I did end up with what I think is a better result than then provided solution.

Spoiler

I noticed there were 3 records with a phone number that was not accounted for in the solution (my records highlighted in red below)


I also didn't like how the FAX records had the word ' fax' in them and similarly that Notes had the '...' at the beginning and end.  I cleaned those up as well.

[Mikkel_D_Karlsen]

Thanks for a great challenge, here is my solution

[MarMu]

That was one time consuming nut to crack. Quite a few hours went into finding the right RegEx expressions. The rest was pretty straight forward.

CReW-macros really helped speed up the validation with their awesome test macros. kudos

Spoiler

[tammybrown_tds]

Full disclosure...I had to peak to the REGEX statements right.  These challenges are a great way to learn Alteryx, though, even if they aren't completed without peeking.