Challenge No. 361: Separate out the largest sequences of English alphabets and numbers from the given strings.
Solved using: Python in Excel.
MID
Extracts a substring from a text string at a given position in Excel.
Digits with Higher Frequency
Challenge No. 356: List the digits whose frequency is > frequency of the maximum digit
Ex.
Solved using: R.
Find Insolite Numbers
Challenge No. 350: List the Insolite Numbers – A number is Insolite if it is divisible by both
Sum of square of its digits AND
Product of square of its digits
Ex.
Solved using: Python in Excel.
Convert to Pig Latin Cipher
Challenge No. 348: Pig Latin Cipher – A new encrypted word is created with 3 components –
Component 1 – String having all alphabets from first vowel occurrence till end of the word
Component 2 – String having all alphabets before first vowel occurrence
Component 3 – String “ay”
Anything other than the English alphabet will be left as it is.
Solved using: R.
Replace letters with nearest vowels
Challenge No. 346: The string contains only English alphabets.
Solved using: Python in Excel.
Sum digits along diagonals of grid
Challenge No. 345: Find the sum of digits of both the diagonals for the grids given.
Solved using: R.
List all Katadrome numbers
Challenge No. 344: List all Katadrome numbers.
Solved using: Python in Excel.
Find nearest Palindrome numbers
Challenge No. 343: Palindrome number is that which is same even when read backwards.
Solved using: R.
List valid South African National IDs
Challenge No. 342: List the valid South African National IDs (person identification numbers).
Solved using: Python in Excel.
Sort odd positioned numbers
Challenge No. 341: Sort the numbers at odd positions.
Solved using: Python in Excel.