Challenge #458: Masking Alternating Characters

[AYXAcademy]

Hello Community members,

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

This week’s challenge, submitted by Alex Abi-Najm ( @alexnajm ), is a fun puzzle for you to practice your parsing and formula skills. Who is up for the challenge?

The dataset contains three rows of data. Your task is to mask every other letter in a word with an asterisk. So, for example, if the rows contain the following data:

HAPPY HOLIDAYS

BE JOYFUL

The result should look like this:

*A*P* *O*I*A*S

*E *O*F*L

Make sure you don't mask any spaces!

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

• Changing Data Layouts
• Multi-Row Formula

Good luck!

The Academy Team

Download Start File

Download Solution File

[alexnajm]

Thank you @AYXAcademy for posting my challenge! 😊

[alexnajm]

Spoiler

[Bobbyt23]

Great challenge @alexnajm my solution was almost identical to yours. Though it took me a few goes trial and error to work out what to do with the spaces to make sure I matched the solution.

Spoiler

[AYXAcademy]

Thank you, Alex, for your contribution!

[balajilolla2]

Spoiler

Solution Attached

[olga_strubbe]

This was a fun challenge, thank you, Alex ( @alexnajm )!  It was a good practice of Multi-Row tool and Mod function.  Especially it helped me with my practical application of Mod function.  I chose to use the same approach to solve it as it seemed the most straightforward to me. 

Spoiler

[olga_strubbe]

Sorry, I forgot to attach a screenshot of my workflow.  Here it is: 

[mmontgomery]

C458

Spoiler

[Kenda]

Spoiler