Challenge #20: List Parsing

[RWvanLeeuwen]

I have a near perfect match - it's just that for the phone numbers I have a 1.03% null whereas the solution has 0.98% null so I am not sure what I have missed here... I think my approach is still valid and if you happen to miss the info it will still be in the address line.

Spoiler

[Reesetrain2]

All,

So I noticed that every entry once you filtered out the Nulls was two new lines, as I was able to identify where the Company names were, but then I had to result to parsing as I coudn't really get much beyond the company name with the line breaks. If anyone knows how to order and then find a way to go from there, it would have been interesting to see what I could have done with the company groupings.

Anyway, since I had the two competing methods, my solution is extremely long.

-Cheers!

Spoiler

Matt

[piotrzawistowski]

Done. Many regexes in one Formula was the key in my solution.

[Alekh]

Spoiler

[fmeo]

Spoiler

This was one of the first Advanced challenges I did

[jagdeep_singh85]

Hi,

PFA my solution

[ADerbak]

Solution Attached!

[David-Carnes]

Definitely went down the rabbit hole in my first attempt, mainly in trying to establish boundaries between records.  I ran into too many exceptions that I wisely abandoned that idea.  Then I figured out there was one row type that I could pattern match with Regular Expressions and easily handle all variations.

Spoiler

[KMiller]

Such an awful challenge. I need to revisit this and structure the solution differently but got it down to 39 differences so happy with this.

Spoiler

[EmilyCR]

Talk about head wrecking!