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 #40: Parsing a HTML File

TomWelgemoed
12 - Quasar

Liked this one. I revised/improved it slightly after seeing the solution.

 

Spoiler
TomWelgemoed_0-1615326383236.png

 

LHolmes
9 - Comet

Getting better with practice on this, but will probably spend some time looking through solutions.

 

Spoiler
040 - Solution.PNG
Toons
12 - Quasar

My solution:

 

Spoiler
Toons_0-1615848967026.png

 

rcarog
8 - Asteroid

Solution attached.

KilianL
Alteryx Alumni (Retired)

Nice parsing challenge.

I like to use the comment tool to keep the relevant code visible while building out the workflow.

 

Spoiler
040 - Parsing a HTML File - Kilian.png
AllexJia
8 - Asteroid

My solution:

Spoiler
AllexJia_0-1618216016473.png

The second solution is learnt from the provided solution.It's so cool!

Maskell_Rascal
13 - Pulsar

Here is my solution!

 

Spoiler
Maskell_Rascal_0-1619558334969.png

 

Cheers!

Phil

cchandler21
Alteryx Alumni (Retired)

Solution Attached

jjrbondoc
8 - Asteroid
Spoiler
jjrbondoc_0-1622540327089.png

 

Here's my solution

Erin
9 - Comet

!!TROUBLE!!

 

Spoiler
For some reason, this formula: Replace([DownloadData], "</span><br/>", "|") is not working for every line. So I am unable to parse city for a small percentage of rows as I cannot get the pipe in the text. Not sure what I am doing wrong?