Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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

kcgreen
8 - Asteroid

I was stuck until I peeked at some of the solutions and saw the text to columns tool could be used for text to rows as well.   From there I just multi-rowed my way to a solution.  

 

Spoiler

 

45.JPG

 

Gauthier_B
8 - Asteroid

Done!

Was a fun challenge, took me a while to figure it out.

OllieClarke
15 - Aurora
15 - Aurora

Learnt a lot during this one :)

 

Spoiler
Challenge 45.PNG
TimothyManning
8 - Asteroid
Spoiler
45. Data Parsing Screenshot.png
robbinrv
8 - Asteroid

My workflow below

 

Spoiler
Spoiler
Alt_Chal_45.PNG
paul_houghton
12 - Quasar

Another one done :)

 

Spoiler
Challenge 45 Complete.jpg
asabau
8 - Asteroid

Nice practice of Regex!

KOBoyle
11 - Bolide

Solution attached.

dsmdavid
11 - Bolide

Went a different (and looonger road). Nested macros.

 

Spoiler
Main workflowMain workflowFirst Batch MacroFirst Batch MacroInside Batch MacroInside Batch Macro
justynam
8 - Asteroid

Challenge solved!