Challenge #35: Data Cleansing Practice

[amcollen]

Fun stuff!

[namrad]

Attaching my solution

[Vikash_kumar]

Solution attached

[Mattyb21]

Solution attached 

[Guillaume_G]

Here you go !!

[Rohit_G13]

Good exercise to practice simple ways to clean and standardize data

Regards

Rohit Govind

[WouterWelman]

My Solution

[KilianL]

My take on this challenge:

Functions used:

Spoiler

TrimLeft(String,y)

TrimRight(String,y)

iif(Length([Safety Code])=6,'SC'+[Safety Code],left([Safety Code],8))

[DavidLane]

Though it is possible to use the data cleansing tool for some of these steps, I have found it is much faster in terms of runtime to use a specfic formula for the job.

Spoiler

[Oren_Soloman]

Challenge Submission