Challenge #35: Data Cleansing Practice

[CandiceDB]

My solution:

Spoiler

[ayazsheikh]

Resolved

[Erin]

Spoiler

I noticed on the first exercise, the output data type is an Integer. I added to my formula to convert from string: ToNumber(Trim([Field1],"0")).

I followed that same idea on exercise 2 final formula: ToNumber(Trim([RegExOut1],"0"))

[vbrown]

My solution.

[KFarmer]

Spoiler

These are my solutions

[MichelleL]

🤗

[apathetichell]

my solution...

[rachit1493]

My take on the solution!

[AntDavis42]

Solution

(felt like one was redundant)

Spoiler

[RamonaJ]

Attached my solution