Challenge #35: Data Cleansing Practice

[Ruban]

Formula for the last part: 

IF Length([Safety Code]) < 8 THEN "SC" + [Safety Code]

ELSEIF Length([Safety Code]) > 8 THEN Replace([Safety Code],Right([Safety Code], 14) , "")

ELSE [Safety Code] ENDIF

[jomongeorge]

Solution Attached

[pmyers]

My solution attached.

[amjadmanasra]

Hi Data Hero,

one minor comment, 

to remove leading zero you need left trim not a trim function, trim will remove from both end of the text 

[Thomas_Wells_2dot0]

Kind of a random set of data cleansing requests, but oh well! 

Spoiler

 

[Swathi]

PFA the solution

[Travis_Ratliff]

Solved

[mkbhagat]

Here is solutions of Data cleansing . 

[Jodelgado518]

My solution

[nidhirana15]

Solution