Challenge #35: Data Cleansing Practice

[mhou]

🙂

[Sheniga]

For first 2, just using select is enough, 3rd used trim function with select, 4th this formula

IF Length([Safety Code])=6
THEN "SC"+[Safety Code]
ELSE Left([Safety Code],8)
ENDIF

[schenkelpat]

Solution

[ALexAn]

Solution Challenge#35

[jarrod]

lots of Trim and PadLeft

Spoiler

[vaishabhinav_iitm]

Spoiler

[Sami1]

Challenge done.Suggestions are welcome

[Sami1]

I used something different

IIF(StartsWith([Safety Code], "C"),"SC"+[Safety Code],[Safety Code])

Works!

[MarielJinang14]

Spoiler

[vinodkumar_mandora]

.