Search

Close

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

🙂

Weekly challenge completed.

answer attached

My Solution:

My Solution

Illustrates usage of the following tools & methods

-> TrimLeft

-> Formula

Functions used: length, Len, PadLeft

-> Regex

Actions used:

Replace

Grouping

Anchor Operators:

^ for start

$ for the end

| for OR

-> IF THEN ELSE ENDIF Block

flexed my regex here