Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #45: Parsing Bureau of Labor Data

papalow
8 - Asteroid

The thrill of solving.....

RichoBsJ
11 - Bolide

Hi! Here my solution :)

cplewis90
13 - Pulsar
13 - Pulsar

This was a challenging one, but allowed me to increase my RegEx skills. I wish I knew how to have RegEx do a repeating pattern so I didn't write out a super long formula. 

Spoiler
Challenge 45.PNG
KMiller
8 - Asteroid

Solution attached

Spoiler
05-03-2019 09-03-48.png
kelly_gilbert
13 - Pulsar

The file at that URL has changed (different years are included now), so my results don't match the solution. I think I got the process, though!

 

Spoiler
challenge_45_workflow.png
Thableaus
17 - Castor
17 - Castor

Challenge #45, done.

 

When you're more familiar with iterative macros, things are easier and quicker to do.

Nested iterative macros nail this challenge with a few tools.

MacroToParseYears.PNGMacroToParseCategory.PNGChallenge_45.PNG

 

Cheers,

T_Willins
14 - Magnetar
14 - Magnetar

Another challenge down, another evening playing with Regex

 

Spoiler
Workflow 45.GIF
Suzu
9 - Comet

Here is my solution.

hbraunius
8 - Asteroid

my solution attached.

Eleonora
8 - Asteroid

My solution

 

Spoiler
challenge 45 solution Eleonora Nazander.JPG