Weekly Challenges

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

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

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

Challenge #35

my sol

My solution.

Weekly Challenge

Here is my solution to the challenge above;

1. Remove leading zeros using IIF:

2. Trim leading zeroes and/or descriptive text at the end using RegEx

3. Remove ID:

4. Remove & replace characters based on the length of strings:

Here is my solution.

Done

Reposting under my new user ID.

my solution

Challenge #35: Data Cleansing Practice