Challenge #45: Parsing Bureau of Labor Data

[Natasha]

Used generate rows and regex but in a slightly different order. Also the data is updated to contain 2016 vs 2015 data

Spoiler

[JoshKushner]

Thought it was going to be impossible, but it was actually not too bad!

[samN]

Got a few more rows than the solution file but i think its just updated. Fun little parsing challenge

[ggruccio]

Fairly challenging!  My data was from 2007 to 2016 also...great parsing exercise.

[PhilipMannering]

Regex to the rescue. I feel like I used fewer tools than most sooooooo..... go me.

Spoiler

Regex heavy

[LandonG]

Solution attached.

[jasperlch]

Solution attached.

[msicak]

the good old multi-row tool. And to think I did not understand/get its use the first time I came across it! 

Spoiler

[dominiklz]

Spoiler

that was quite something, messy data is messy, but cleaning it feels so rewarding :-)

[JosephSerpis]

Challenge Completed