Challenge #45: Parsing Bureau of Labor Data

[Lucatelli]

Please find attached my proposed solution.

[FlorianC]

There are, as always, multiple ways to address this challenge. This one might not be the shortest but I believe that breaking the process down in detailed steps creates a self-documented workflow that can be easily audited and maintained.

Spoiler

Workflow

[danicahui]

Spoiler

[TiwariVaishali]

My Solution

Spoiler

[JethroChen]

Spoiler

[treepruner]

I have 60 more records than the end result, but the numbers look the same at the beginning of the file. I checked the official solution file and it has a year filter that removes several hundred rows that I don't see in the original challenge spec, but up to that we more or less had the same logic...

. 

[Owaisf]

@NicoleJohnson's solution really gave me the proper insights to solve this solution with the help of Regex code effectively. I really had a hard time solving this one, because I picked advanced exercise "knowingly", even though I am just a beginner,  but I learned some new tools today, thanks for the solution @NicoleJohnson 

[JoePC]

Solution Attached

[AngelosPachis]

My solution for Challenge #45. Output has changed since the challenge was published, I ended up with 1500 rows.

Spoiler

[AkimasaKajitani]

My solution.

The download file has changed since this challenge is published.

Spoiler