Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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 #477: Poetic RegEx for Mother’s Day

patrick_digan
17 - Castor
17 - Castor
Spoiler
image.png
mjacob530
5 - Atom

Fun challenge!

 

Spoiler
SpoilerSpoiler
SteveY02
8 - Asteroid

Done, Cost half an hour to test reglur expression.

messi007
15 - Aurora
15 - Aurora

My Solution !

 

Spoiler
Capture d’écran 2025-05-28 163106.png
danettedavis
8 - Asteroid

solved

fdavy
8 - Asteroid

Here's my solution !

Yoshiro_Fujimori
15 - Aurora
15 - Aurora

My solution.

 

Spoiler
Workflow
Challenge477_workflow.png

Formula Tool
[Poem] =
  REGEX_Replace([Field1],
    "(.*)(\d{2}-[A-Z]{3}-\d{2,4})(.*)",
    "$1, $3")

[Date] =
  DateTimeParse(
    REGEX_Replace([Field1],
    "(.*)(\d{2}-[A-Z]{3}-\d{2,4})(.*)",
    "$2"),
  "%d-%b-%Y")


Word Cloud
Challenge477_wordCloud.png
lukas_olsovsky
8 - Asteroid

Thank you for the fun challenge! It was nice to remind regex expressions once again!

 

Spoiler
477.jpg
EuanGriffith
7 - Meteor

Done. Couldn't work out how to Tokenize, using the Formula tool.

 

Spoiler
477 Complete.yxmd.png

colmoore20
7 - Meteor

what a sweet poem