Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語

IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Solution Attached

Great data cleaning practice using regex.

Spoiler

String functions!

My solution

Formulas used:
TrimLeft to remove leading characters
TrimRight to remove trailing characters
PadLeft to add leading characters
Left to retain X number of leading characters

solution

correction of my mistake on task 3

Solution attached.

My solution without using RegEx tool

Weekly Challenges

IDEAS WANTED

Challenge #35: Data Cleansing Practice