Challenge No. 149: Extract texts between and pair of the bellow characters.
Solved using:Excel (LAMBDA, LET, MAP), Google Sheets, Power Query (Table.AddColumn), Python, Python in Excel, and R.
Text Processing
Handling text-based transformations.
Group Text by Keyword
Challenge No. 235: Populate the Groups (from table 2) on the basis of words appearing in Text column.
Solved using: Power Query.
Case-Sensitive Baconian Cipher
Challenge No. 212: (Baconian Cipher – This problem is case sensitive)
A/a is 0, B/b is 1, C/c is 2.
Solved using: Power Query.
Encrypt Using Date Cipher
Challenge No. 207: DATE CIPHER
Date cipher is a type of Caesar’s shift cipher where key is current date in YYYYMMDD format.
Solved using: Excel VBA.
Encrypt Using Baconian Cipher
Challenge No. 203: Baconian Cipher
(This problem is case insensitive)
A is 0, B is 1, C is 2.
Solved using: Power Query.
Convert Dates to US Format
Challenge No. 181: Convert DMY text dates to MM/DD/YYYY format.
Solved using: Power Query.
Route Cipher Encrypt
Challenge No. 178: Route Cipher
Encrypt the given Strings.
Solved using: Power Query.
XOR Cipher for Message
Challenge No. 173: This time, in step 3 in place of adding both the numbers, we need to do Bitwise XOR operation.
Solved using: Power Query (List.Transform).
Pad In The Middle!
Challenge No. 125: For the IDs in the table, insert zeros between the text and numbers to ensure that each ID has exactly 6 characters.
Solved using:Excel (CONCAT, ISNUMBER, LAMBDA), Google Sheets, Power Query (Text.Repeat, Table.AddColumn), Python, Python in Excel, and R.
Vernam Cipher Encrypt
Challenge No. 162: Vernam Cipher (also known as One time pad cipher)
1.
Solved using: Power Query (List.ReplaceMatchingItems, List.Transform, List.Zip).