Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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?