Challenge #477: Poetic RegEx for Mother’s Day

[TH]

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]

Fun

[Yoshiro_Fujimori]

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

Spoiler

My solution:

Workflow

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

[Ziteng]

fun practicing some RegEx! 

[Chuks01]

[jrlindem]

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

Spoiler

[Dhrish]

Solution

[rmassambane]

477