Challenge #35: Data Cleansing Practice

[pawanmalik]

My solution for the problem.

[Gomes]

See my solution.

[Anchal_]

Attached is my solution.

[Leanne1]

Still learning expressions in the Formula Tool. Whew!

[JoePC]

Solution attached

[priya-18]

My Solution, tried RegEx tool

[vipul_2710]

Here is my solution to the challenge

[shock7772]

Spoiler

SPOILER

[kevin025]

The fastest way for Problem 2 is

Spoiler

Use Regular Expression

You can test your regex at regex101.com
Your test string will be:

001001
1001: Report
00123456
1234

My regex is for this problem is:

Spoiler

(1.+[1-6])

Have fun!

[Milanz]

I like this one 🙂

Spoiler