We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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

myastarling
10 - Fireball

Here's my solution. This also corrects the error on line 649 in the output where the practice is listed under city.

caltang
17 - Castor

Done!

 

Spoiler
image.png
Computernerd
8 - Asteroid

There's actually an error in the Answer Dataset at Row 629.

lwolfie
10 - Fireball

Fun challenge.  I don't use HTML parsing much, so it was great to practice.

Tgigs
8 - Asteroid

My solution attached.

 

Had to look at the solution. Would have helped if I could open the web page but seems to no longer work. Nonetheless, great exercise for parsing HTML data from web pages.

afnfyz
8 - Asteroid

Regex really shines when it comes to parsing data. Simplifies the workflow so much.

Spoiler
Screenshot 2023-10-27 212902.png
DanielG
12 - Quasar

Solved

olga_strubbe
10 - Fireball

Please see my solution attached.  This was a tough one.  I leveraged the logic in the solution provided in terms of RegEx Replace functionality. 

Thank you.

Carolyn
8 - Asteroid

Solved. I first tried to do this with just RegEx but even after looking at some of the solutions with just RegEx, I didn't quite understand it all. So though I got it to work, I redid it with the Text to Columns + Multi Rows and it ended up a bit ugly, but I got there. I'm happy it's done :) 

 

Spoiler
2023-11-13_12-22-27.png

TimN
13 - Pulsar

Hi,

Here is my solution.