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 #120: Popular Baby Names

WouterWelman
7 - Meteor

Not sure of my methods, but results seem to work.

 

rgizm0
6 - Meteoroid

A little messy, but same result 🙂 

dchristian
7 - Meteor

nice! mine was a lot more complicated, but, as you say, it got the job done.

knl538
6 - Meteoroid

I tried to use the least amount of tools for the challenge. Completed and attached.

EdE
7 - Meteor

My solution is attached!

mhou
8 - Asteroid

🙂

TiwariVaishali
8 - Asteroid

My solution

VizChic
11 - Bolide

Congrats Vaishali 🙂 you're doing an amazing job at completing the challenges

kmuralid57
7 - Meteor

Solution, KSM.

izamryan
8 - Asteroid

I think my solution is a little clunky as it's not terribly elegant.

 

Spoiler
izamryan_0-1590146110598.png


Instead of using Regex I used a Formula tool with:
trimright(TrimLeft([FileName],"names.zip||yob"),".txt")
to slice out the year data from the [FileName] field