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

vmazur24052020
8 - Asteroid

RegEx rules

kaiserj
8 - Asteroid

😀

Maxine
8 - Asteroid

The other solution I created with fewer steps involved and annotations on.

nSpire
9 - Comet
Spoiler
013.png

beatriz_alteryx06
8 - Asteroid

Solved

My solution

Spoiler
3.png
mshishido
8 - Asteroid

reposting because I lost my original solution

SJKIM
8 - Asteroid

Done

danbostrom
8 - Asteroid

 

 

DaisukeTsuchiya
14 - Magnetar
Spoiler
スクリーンショット 2024-08-16 180624.png
Zongkai
8 - Asteroid

Don't like this practice.

It is supposed to use XML parse tool. But no matter how to configure the tool, it cannot parse the input file. Probably it's because the XML in the input file is not well written.

 

 

Spoiler

After all, used <t[^d][^>]*> to remove all info except <td ... >, then replace <td> </td> <tr> </tr> with a delimiter.

First time to use make columns to rearrange the data.