Challenge #20: List Parsing

[AlexCox]

My solution

I noticed that record numbers 1652 and 1653 are duplicates of 1651 "Stateside", I included my original workflow that gets rid of them.

[ipeng]

This one is challenging, but I learned something new! Solution attached. 

[PhilBalderson]

Super cool. Iterating record numbers using multi-row tool was my big learn today! 

[rfergus]

Used a different approach than most solutions I saw and got some different results for a few of the bad addresses and phone numbers but overall I think it works fairly well.

Spoiler

[Verakso]

@Laurap1228 have said it all!

I had to do many many iterationer (cheating and sneak peaking at the solution) many times before I got the expected result

Spoiler

Finally....

I'll think I'll skip the Advanced challenges for a while, but it was a great exercise, and still a lot of fun.

Still climbing
/Thomas

[RolandSchubert]

My solution ... I still don't enjoy using regular expressions, but I habe to accept, that they are really useful.

[Sajeel_Kershi]

hmm bit of a brute force effort; not as elegent as the provided solution

a lot of conditional checking and multi row tools

[FeedMeData]

This one was killer! Took me ages

[Anastasiia]

Here is my solution

[Thableaus]

Challenge #20, done!

Definitely the toughest one so far. I had to change my mindset of how I was going to do this so many times. Also, it was trial and error all the time to find out the best strategy and reduce steps.

Spoiler

Cheers,