Challenge #174: Appyhay Ondaymay!

Going to submit this, it's not quite 100% as the logic doesn't deal with any punctuation within the phrases, but it's close enough for the time I've boxed for completing it.

Spoiler

challenge_174_solution.yxmd

danilang

Unfay allengechay.

Ooklay Amay. Iyay uiltbay ayay ordsway

Spoiler

Break it down to letters. Find the split between front and back. Swap the front and back part. Add the suffix and build it back up.

anDay

challenge_174_solution_DL.yxmd

viveknshah

Spoiler

Could have streamlined the RegEx together but needed to break it out to make sure I was doing it right.

challenge_174_viveknshah_soln.yxmd

estherb47

Challenged myself to do it without RegEx, and it worked!!!

Learned 2 new functions in the process, STRSPN and STRCSPN. Try them out to test for vowels and punctuation.

Spoiler

Probably could have simplified my formula tool, but wanted to think it out a piece at a time, and also maintain the punctuation marks and capitalization scheme of the original

FUN!!!!!!!!! @danilang , we finally take different approaches 😉

challenge_174_EHB_completed.yxmd

Kenda

Spoiler

Those trailing spaces got the best of me

challenge_174_start_file.yxmd

bnelly1987

Wow! That was a tough one. Probably would have helped if I understood Pig Latin prior to doing this.

Spoiler

challenge_174_start_file.yxmd

echuong

got everything except for the capitalization!

challenge_174_start_file.yxmd

T_Willins

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

challenge_174_solution.yxmd

ggruccio

EryVay appyhay ithway ethay esultsray!

challenge_174_gg_finish.yxmd

NicoleJohnson

Egexray orfay ethay inway!

Spoiler

Eerschay! 🙂

challenge_174_NicoleJohnson.yxmd

lmorrell

icksay oneyay

Spoiler

challenge_174_LM.yxmd

Martyn

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

challenge_174_complete.yxmd

danilang

Hi @estherb47

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

Dan

bkclaw113

Spoiler

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

klyuka

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

...

challenge_174_solution_ayklyuka.yxmd

Leo_Conjecto

Spoiler

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!

WC174_Dantas_Leonardo.yxmd

danilang

Hi @bkclaw113

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

Dan

mestevez1

I got 90%. I could not get capitalizations and the word "Don't".

challenge_174_mestevez.yxmd

mmenth

Spoiler

challenge_174_menth_solution.yxmd

jamielaird

Here's my solution.

PS - love the new leaderboard - thanks @JoeM !

Spoiler

challenge_174_JL.yxmd

Eleonora

Wasn't an easy challenge, but I am happy I didn't give up!

Spoiler

challenge 174 solution Eleonora Nazander.JPG

challenge_174_Solution Eleonora Nazander.yxmd

kelly_gilbert

You know it's a good challenge when it involves regex and potty humor! I could have been more sophisticated with the regex, but at least this makes sense to me.

I allowed letters and apostrophes as part of a "word"... Therefore, my solution would treat a hyphenated word as two separate words (e.g. "ixtysay-eethray").

Spoiler

challenge_174_solution_klg.yxmd

Jbrooks

Spoiler

Might be the hardest one I have done yet

challenge 174_JB.yxmd

Nacho

Here's my attempt

challenge_174_start_file_IT.yxmd

Ladarthure

My solution, very funny one, needed time to understand the piggy but finally made it !

challenge_174_start_file.yxmd

LordNeilLord

One of the most infuriating challenges!

Spoiler

challenge_174_LNL.yxmd

Wouter

Atthay asway uiteqay ayay rainbay easertay. Ere'shay ymay olutionsay:

Spoiler

challenge_174_solution_WK.yxmd

DanielMS

Spoiler

Dan_Salway_challenge_174.yxmd

OllieClarke

"Don't" took some fiddling. Also the answer has "Youyay" whereas my answer had "ouyay" which I thought was more in-keeping with Wiki's rules...

Spoiler

challenge_174_OC_solution.yxmd

Ruud

Spoiler

Kinda lowkey disagree with the solution, but my solution isn't correct either (I think "I'm" is 2 words, not 1, but I'm not parsing the m correctly either). Anyway, back to work.

challenge_174_ruud.yxmd

zjosephson

Spoiler

challenge_174_josephson.yxmd

shnbrb

Usedyay isthay allengechay otay ytray andyay actisepray omesay Egexray. Ealingday ithway ethay eadinglay andyay ailingtray itespacewhay asway unfay. Iyay alsoyay otgay ippedtray upyay ybay yyay asyay ayay owelvay.

Spoiler

Pig Latin Decoder for next week?

challenge_174_shnbrb_solution.yxmd

phottovy

Very fun problem. I learned a lot about Regex. I initially used a python script (which is included) but thank you to @estherb47 for introducing me to the STRCSPN function which allowed me to solve it without python.

Spoiler

challenge_174_ph_solution.yxmd

garthn555

Iyay ontday understandyay ouryay econdsay ordway

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335