Challenge #35: Data Cleansing Practice

[Lakshmi96]

solution

[mohitch]

Solution

[dpatnaik97]

Done and attached.

[CKP]

My solution

Spoiler

[Skrupczak]

I used some formula tools, and some regex, since I can always use practice with that! 

[pagrawal]

Spoiler

spoiler

[aman_goyal]

Please check my solution -

[aman_goyal]

Easy Challenge - Easy Solution

[chinedu]

I have a challenge with the last exercise

I ran the following in the formula tool:

IF Length([Safety Code])>8
THEN Left([Safety Code], 😎
elseif Length([Safety Code])=6
then PadLeft([Safety Code], 2, "SC")
ELSE [Safety Code]
ENDIF

but cant get the desired result. It did not Padleft "SC'" to record output 1.

Can someone please help me with this?

Thanks

[DataSciencePro]

Done!