Challenge #155: March Cryptanalytics

We've received the following repeated transmission, but our communications channel is just so unreliable!
We think if we analyze each string for the most frequent character in each position we can reconstruct the message.

Yesterday we received the following:

Htl2!
ce+lo
ve8lz
HDlcF
u8pho

We reasoned that since we received 'H' in the first column the most times, and 'e' in the second column the most times, we think the greeting "Hello" was sent.

Can you help?

challenge_155_start_file.yxzp

Parse

Join

Preparation

Advanced

Data Analysis

Intermediate

Transform

Accepted answers

philipmannering

Love these kind of challenges. Two solutions below,

Spoiler

Workflow

Workflow

In the Python Tool

In the Python Tool

Challenge 155 - March Cryptanalytics.yxmd

All comments

Nice one ...!!

challenge155.yxwz

Good one 😂

Spoiler

challenge155_CH.yxmd

Spoiler

summarize

challenge155.yxzp

Thank you, @TerryT , this is a fun challenge!

I used a similar approach as @kat - it seemed the most straightforward to me by using 'Tokenize' RegEx tool to break the data into rows by character and in the end concatenate the most frequent characters by their position to discern a message.

challenge155_OS.yxmd

Solved

St Patricks in November. I'll drink to that.

challenge 155 finished.yxzp

Done

Solution challenge 155.yxmd

Spoiler

challenge155_GKZ.yxmd

love this challenge!

PFA for solution

challenge155_solutionSM.yxmd

Thanks for the challenge! Here's my solution:

Challenge 155_BS.yxzp

Spoiler

Screenshot 2024-02-06 091119.png

challenge155_complete.yxmd

Solution attached below - I decided to practice working with iterative macros for this one

Spoiler

challenge_155_solution_RS.yxzp

my solution ;-)

Spoiler

challenge155ML.yxmd

It was fun to solve it

Solution_challenge155.yxmd

That challenge was no joke, until I got my head around the code!

Weekly Challenge 155 05-07-24.yxzp

Love this fun challenge!

challenge155_Silje.yxzp

Got that one on the first try!

challenge155_Solution_LW.yxmd

Spoiler

challenge155_submission_EM.yxzp

Really fun! This reminded me of the Advent of Code challenges

Spoiler

challenge155.yxzp

Good one!

Spoiler

Challenge 155.png

challenge155_Alex Abi-Najm.yxzp

challenge155 CTM.yxmd

🏠

challenge155.yxmd

my solution attached

challenge155_JB.yxmd

RebekaMazuchova

At first I thought the Field Summary Tool was going to help me with the most common value. Turns out it doesn't do that!

challenge155_RM.yxmd

Fun

my_solution_155.yxzp

. . . Interrupting Cow?

challenge_155_solution.yxzp

Quick Links

Tags

This months top contributors

Hollingsworth 335