Challenge No. 388: Kamasutra Cipher 2 – Generate 13 random pairs from English alphabets and 5 random pairs from 0-9 digits and use that to encrypt the plain text.
Solved using: R.
Text Processing
Handling text-based transformations.
Generate Kamasutra Cipher Encryption
Challenge No. 382: Kamasutra Cipher – Generate 13 random pairs from English alphabets and use that to encrypt the plain text.
Solved using: Python.
Encrypt Text with Keyword Cipher
Challenge No. 377: Encrypt the gives words using Keyword Cipher.
Solved using: Python.
Text Mapping Between Tables
Challenge No. 130: For Table T2, look for value column of Table T1 in City/Country and Text columns of Table T2 and prepare the mapping shown in Result table.
Solved using: DAX.
Decrypt using 5×76 transposition cipher
Challenge No. 335: This is a 5 x 76 transposition cipher, where you start with the letter in the final position (‘W’) and then repeatedly step back through the whole ciphertext 5 positions at a time time, and then repeat that same process but starting from the letter one before the last position (‘T’) etc, revealing the first words of Geoffrey Chaucer’s ‘Canterbury Tales’.
Solved using: Python in Excel.
Pattern Length!
Challenge No. 194: For each date, samples are evaluated based on quality and marked with a “+” sign if they are within range and a “-” sign if they are out of range.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (List.Transform, Text.Remove, Text.Split), Python, Python in Excel, and R.
Text Split
Challenge No. 57: Split the group of texts into single characters
Dynamic array function allowed, but extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.
Convert Text To Number!
Challenge No. 190: Write a formula to convert texts into numbers.
Solved using:Excel, Google Sheets, Power Query, Python, R, and VBA.
Find texts that are ATBASH Palindromes
Challenge No. 314: ATBASH Palindrome – In ATBASH cipher, we replace a with z, b with y, c with x.
Solved using: Python in Excel.
Replace Consecutive X!
Challenge No. 185: In the ID column, Replace all instances of “X” if it appears consecutively more than once with just an “X”.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (Text.Combine, Table.Group, Table.TransformColumns), Python, Python in Excel, and R.