Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #174: Appyhay Ondaymay!

T_Willins
14 - Magnetar
14 - Magnetar

I also learned the STRCSPN function in this challenge.  I really enjoyed this one as it forces you to look at data in an atypical way.

 

Nubext wubill wube trubanslubate ubintubo ububbubi dububbubi? (but only if you watched Zoom on PBS!)

 

Spoiler
Workflow 174.GIF

 

 

ggruccio
ACE Emeritus
ACE Emeritus

EryVay appyhay ithway ethay esultsray!

NicoleJohnson
ACE Emeritus
ACE Emeritus

Egexray orfay ethay inway!

 

Spoiler
WeeklyChallenge174.JPG

Eerschay! 🙂

NJ

lmorrell
11 - Bolide

icksay oneyay

 

Spoiler
Snag_19d9dda5.png
Martyn
9 - Comet

All fairly straightforward - but got caught out by the "Title Case" within my REGEX_Match function. Who would have thought that even though using \u to detect upper case letters that you would still need to specify case sensitivity!?!

 

Spoiler
clipboard_image_0.png
danilang
19 - Altair
19 - Altair

Hi @estherb47 

 

Well, you know the second half of the "Great Minds" expression.

 

Dan

bkclaw113
9 - Comet
Spoiler
Week174.PNG

I was not able to attach my completed workbook, so hopefully a picture works for credit.

klyuka
8 - Asteroid

My solution is dirty one - using string formulas and iif cases to create words for replacement.

But I don't need to use RecordID Tool and to deal with punctuation keeping.

Only thing I haven't done - parsing Upper-case. 

***

I thought this challenge could has a beautiful solution with LR(1) parcer. 

Such parcer will be written as a number of rules for itterative substitutions vis Alterix FindReplace Tool.

 

Stage 1  - move start consonant to end of the word

" " + Stage0 + consonamt -> " " + consonant + Stage1

consonant + stage1 + letter -> letter + consonant + stage1

consonant + stage1 + " " -> stage2 + consonant  + " "

 

Stage 2 - back to the beginning

letter1 + stage2 + letter2 -> stage2 + letter1 + letter2

" " + stage2 + letter = " " + stage3 + letter

...

Leo_Conjecto
5 - Atom
Spoiler
clipboard_image_0.png

I tried to organize the workflow breaking it by criteria:

 

Criteria 1 - Begin with one consonant

Criteria 2 - Begin with consonant cluster

Criteria 3 - Begin with vowel

 

* The remaining cells after applying all criterias are all empty values.

 

Hope the comments in the workflow can help to easy understand it.

 

Really nice challenge. Thank you!

danilang
19 - Altair
19 - Altair

Hi @bkclaw113 

 

Unfortunately, The workflow is required to get the credit.  What problem did you have attaching the workflow?

 

Dan