Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAnice! mine was a lot more complicated, but, as you say, it got the job done.
Congrats Vaishali 🙂 you're doing an amazing job at completing the challenges
I think my solution is a little clunky as it's not terribly elegant.
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