Challenge #78: Find the Best Housing Markets

[cgoodman3]

Here's my solution, my answer doesn't match the supplied but I believe that is due to the data via the API changing.

Spoiler

Had some issues finding a suitable delimiter, so used a method that I've used before that uses the regex_countmatches formula to identify where records may be split over a more than one line.

[T_Willins]

Solution and bonus solution (both in spoiler; only bonus attached).

Spoiler

[mbogusz]

Interesting when this challenge took place- only 5 months before the housing market peaked in January 2018.

Thanks in part to the masterful RegEx formula @estherb47 used, especially the [A-Z-]* part. That got me to the end.

Spoiler

Solution with help from othersHaving fun with RegEx 101 to come up with the harder parts of the solution

[CaraI]

I took it as a challenge to do this without RegEx ... using the ReverseString function to take care of the non-standard marketing names.  I have a bit of extra cleansing that wasn't needed to solve the challenge but necessary to appease my OCD 🙂

Spoiler

[hanykowska]

Think I managed to get it right, although the values I get for April 2017 are slightly different...

Spoiler

[wale_ilori]

This was truly insightful and challenging but happy I understand the regex functions better.

[jagdeep_singh85]

PFA my solution

[mhgarcia]

Solved!

[RoDO]

My solution

Spoiler