Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.

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

estherb47
15 - Aurora
15 - Aurora

another fun regex challenge


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

Laurap1228
11 - Bolide

This was a fun one! I got to practice my Regex and use a new tool, Make Columns. Might not be the most efficient solution but I struggled to come up with a solution that involved fewer tools.

 

 


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

LordNeilLord
15 - Aurora

Very slowly working my way through!

 

Here's my solution:

 

Spoiler
Weekly Challenge 13.png
DE0413
8 - Asteroid

This was quite the challenge--not sure that it's a repeatable process but I reached the desired output:


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

jacob
6 - Meteoroid

 


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

Pavel_G
6 - Meteoroid

My third one is done. This time I'm uncertain that it's the best solution and if it's allowed to have empty cells instead of "[Null]".

 

Spoiler
Screenshot - 2017-05-31 , 14_44_54.png

 

LordNeilLord
15 - Aurora

Workflow


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

jamielaird
14 - Magnetar

Here's my solution.

 

 


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

nick_ceneviva
11 - Bolide

Solution attached!


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

BenMoss
ACE Emeritus
ACE Emeritus

Here's my solution to this one.

 

I think it should be future proofed in that it would work with multiple records.

 


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.