Challenge #316: Blowing in the Wind - Part 1

[dmason02]

Spoiler

the answer my friend, is blowing in the wind
the answer is blowing in the wind

[patrick_digan]

Spoiler

[PhilipMannering]

Smashed it.

Spoiler

[LiuZhang]

Spoiler

[Reesetrain2]

All,

If you do not like custom code, you will love this, if not, then not so much...

Spoiler

Lets see here:
9 Filter tools
8 Select tools
7Formula Tools
3 Summations
2 Sorts
1 Join
1 Regex &1 text to Column
-This challenge was interesting as the hardest part was the fact that the location had 6 different patterns/combinations as once you got opast that the parsing wasn't that bad. I used a cascade method where I kept using the filter to give me different sets with the same pattern so that I could label them and then I sued a union to bring them back together and a multi-row tool to add back in the county.
-Cheers!
Matt

[daniel_lcp]

done thx

[Qiu]

Can not imagine the speed for above 100MPH...

Spoiler

[kelvin_law1]

Here is my solution:

Spoiler

[josh_dykstra]

done

[dYoast]

I think my parsing could be done better.  I will see what others did.

Spoiler