Challenge #78: Find the Best Housing Markets

[WernerE]

Thanks, was fun as always

[A2H]

Spoiler

[mikecusic]

Nice, tricky parsing challenge! I highly recommend www.rubular.com for testing the RegEx.

[Qiu]

Nice one!

Spoiler

[JP_SDAK]

Great Regex challenge- multiple lines threw me - but finally figured that out.  I might come back and do app later.

Spoiler

[tammybrown_tds]

Spoiler

[JasonHu]

Spoiler

Here is my solution, haven't done the bonus part.

[Tokimatsu]

solved

Spoiler

 

[jdbaldwin]

I can't find anyone else reporting this, but I think I am experiencing a bug.  I am at 2019.3.5.17947.  The bug manifests in both my own build and the solution workbook.

The data that's broken across lines, like:

999 13980 Blacksburg-Christiansburg-Radford,
VA 5425 5425 0 0 0

When I build a new line ouf ot [Field]+[Row+1:Field], I should get 

999 13980 Blacksburg-Christiansburg-Radford,VA 5425 5425 0 0 0

But I actually get 

999 13980 Blacksburg-Christiansburg-Radford,VA

This means that I am missing several rows at the end when I display the sorted results, and, for example, the NYC market line is missing (Others, too.)

Am I the only one?  As I said, this happens even in the canned solution file when I run it under my version.

[OnionKnight]

Super good!!