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.
SUBSTITUTE
Replaces text in a string based on a specific match in Excel.
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.
Route Cipher Encrypt
Challenge No. 178: Route Cipher
Encrypt the given Strings.
Solved using: Power Query.
Common Digits with Frequency
Challenge No. 177: Find the common digits between Number1 and Number2 if the occurrence frequency of a digit is same in both Number1 and Number2 and occurrence frequency of that digit > 1.
Solved using: Power Query (List.Transform).
Name Team Statement
Challenge No. 176: If a single name => name followed by “is in team”.
Solved using: Power Query.
Symbol Replace by Frequency
Challenge No. 163: If an alphabet appears once in a word, replace it with a “?”.
Solved using: Power Query (Table.AddColumn).
Multi Replacement!
Challenge No. 115:
Replace “q” and “000” in the Product ID and Customer ID columns with “-“.
Solved using:Excel (HSTACK, LAMBDA, LET), Google Sheets, Power Query (Text.Replace, Table.ReplaceValue, Table.TransformColumns), Python, Python in Excel, R, SQL, and VBA.
Mask Specific Whole Words
Challenge No. 136: Mask the string with asterisks if a word given in Words column appears in that row.
Solved using: Power Query.
Replace Masked Characters
Challenge No. 131: The strings given in column A have some alphabets which are masked i.
Solved using: Excel VBA.
Format FIFA data with hyphens
Challenge No. 30: — This week is for FIFA world cup challenges —
Insert a hyphen ( i.
Solved using: SQL.