Challenge #45: Parsing Bureau of Labor Data

[joshbennett]

@GeneR - FYI, the URL in the provided input gives a "HTTP/1.1 301 Moved Permanently" error. Upon checking the source (bls.gov), I was only able to find the following file:

• https://www.bls.gov/web/empsit/compaes.xlsx

[joshbennett]

Given the new input file, the beginning of my solution looks a little different due to needing to first download the xlsx as a blob and then read all data from all sheets. Additionally, the new .xlsx appears to have data for 2012-2021, as opposed to the original .txt input which contains data from 2006-2013.

My solution:

Spoiler

Main workflow:

Batch macro 1:

Batch macro 2:

[gautiergodard]

Spoiler

solution 

[lhalliwell]

Spoiler

 

[NicolasSz]

URL is dead :(

[karlhansen]

Spoiler

Data is permanently moved -- use:  https://www.bls.gov/web/empsit/compaes.xlsx

(When I compare mine to the solution, the data almost does not overlap!)

[huyenntran97]

My solution for Challenge 45:

The URL doesn't work

[JoeChan619]

The URL doesn't work :(

[alacoume]

URL is dead, so i will not do it!

[danblythe_RSM]

Spoiler

Had to use a txt file to do this challenge, but still had fun!