Challenge No. 570: For a given string, interchange the alphabets by swapping positions given in Numbers column.
Solved using: Python in Excel.
REPLACE
Replaces part of a text string with another text string in Excel.
Three Regex Pattern Tasks
Challenge No. 552: This time 3 challenges into one to hone your regex skills.
Solved using: Python in Excel.
Find Palindromes by One Deletion
Challenge No. 374: A Palindrome word is that which is same even read backwards.
Solved using: Python in Excel.
Column Splitting! Part 6
Challenge No. 196: Split the ID into two columns:
The first column should contain all letters.
Solved using:Excel (CONCAT, HSTACK, LAMBDA), Google Sheets, Power Query (List.Transform, Text.Select, Table.AddColumn), Python, Python in Excel, and R.
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.
Prime After Digit Removal
Challenge No. 303: Remove the digits in each position and list those numbers which are prime for all occurrences of removal.
Solved using: Python in Excel.
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.
Generate Italian Fiscal Code
Challenge No. 102: This is first part of 2 parts Italian Fiscal Code (Codice Fiscale) generation challenges.
Solved using: SQL.
Count Unique Odd Digit Numbers
Challenge No. 97: Yesterday, I ended up posting a complex challenge.
Solved using: Python in Excel.
Pascal Case to Snake Case
Challenge No. 84: Change Pascal Case to Snake Case.
Solved using: Python in Excel.