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 #13: HTML Table Parsing

lucysinclair62
8 - Asteroid

My very complicated solution below..

I feel like these challenges always leave me thinking "there must be a better way to do this" and then when I read through everyone's solutions, there definitely is!

Spoiler
lucysinclair62_0-1655819264431.png

 

Amol_Telore
11 - Bolide
Spoiler
Amol_Telore_0-1656850294969.png

 

longnt
5 - Atom

longnt_0-1656951167749.png

 

peter_gb
9 - Comet

Little bit regex, little bit manual faff

 

Spoiler
challenge_13_pgb.png

Milanz
8 - Asteroid

My solution ;-)

 

Spoiler
Milanz_0-1657110254016.png

 

acarter881
12 - Quasar

I'll have to research how to parse HTML in Alteryx. This is much easier to do in a programming language.

My output matches, aside from Last Modified By being Last By (I couldn't figure out how to do non-greedy regex, so I ended up splitting on spaces, hence the missing word "Modified").

Spoiler
my_weekly_challenge_13_solution.png
dbmurray
8 - Asteroid

Very similar to posted solution. Fun challenge

 

Spoiler
Screenshot_1.png

 

ferg_smith
8 - Asteroid
Spoiler
ferg_smith_0-1657705727004.png

 

Albert_Vega
8 - Asteroid

Complete! 

Desmond
8 - Asteroid

My Solution