Challenge #477: Poetic RegEx for Mother’s Day

[AYXAcademy]

Hi Community members,

A solution to last week’s challenge can be found here. 

This week's challenge was inspired by a submission from Vikas Gupta. We appreciate Vikas' contribution! It is great to include the versatile RegEx tool in our repository of challenges.

As we celebrated Mother’s Day last week, why not embark on a unique challenge? Use your regular expression skills to clean up a line of a poem that you can write on a card and present to your mom, accompanied by a bouquet of roses.

Your dataset contains a list of lines from poems mixed with the dates they were written.

Your tasks:

1. Remove the dates from the poems and replace each date with a comma.
2. Create a new column that contains the dates formatted in Alteryx date format.

Bonus: If you have the Text Mining palette installed, create a word cloud to discover which words stood out.

Need a refresher? Review these lessons in Academy to gear up:

• Creating Regular Expressions
• Using RegEx in Expressions
• Parsing Data with RegEx

Good luck, and happy Mother’s Day!

The Academy Team

Download Start File

Download Solution File

[martinson]

Great Challenge

[Towers]

fun one! love regex

[DylanBell]

Spoiler

Time Taken: 10:13

Fun challenge!

[Flo_P]

My solution - coming right out of 476 helped!

Spoiler

[Tofel]

Spoiler

 

[3I_ATLAS]

It seems Tuesday is the new challenge release day now....:)

[pilsworth-bulien-com]

My solution:

Spoiler

 

[mmontgomery]

c477

Spoiler

[alineruizcampos]

Spoiler