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

TH
8 - Asteroid

Unfortunately, the regex tool can only do one thing at a time.

Hence, when the process is

1. Get the dates

2. Replace the dates with commas

3. Change the date format

 

then you end up needing three tools where I think that it ought to be done with one or two.

In my solution I used the select tool and the join tool to check my answer against the given answer.

ANNE_LEROY
8 - Asteroid

Fun

Yoshiro_Fujimori
15 - Aurora
15 - Aurora

I submit mu solution again as my previous response was not reflected to the status for some reason.

 

Spoiler

My solution:

Workflow
Challenge477_workflow.png


Formula Tool

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


Word Cloud
Challenge477_wordCloud.png

Ziteng
6 - Meteoroid

fun practicing some RegEx! 

Chuks01
5 - Atom

Chuks01_0-1754500680527.png

 

jrlindem
11 - Bolide

Fun.  Unfortunately, I don't have the ability to do the Bonus, but was a good excuse to dip back into Regex

 

Spoiler
jrlindem_0-1754598145933.png

 

Dhrish
8 - Asteroid

Solution

rmassambane
11 - Bolide

477