Challenge #35: Data Cleansing Practice

[vghazaryan]

My solution:

[JunePark]

Spoiler

trimleft, trimright, if function

[rsalvador]

my solution

[liamholland]

Solution in file:

[KGS]

Hi,

By far the most challenging assignment.

Best,

B

[Hruday]

This is my second weekly challenge Please have a look over the solution.

Spoiler

[dorisdoris]

I had fun!

[Learn2Excel]

1. Remove leading zeros : A) Used 'Select' tool > change data type to 'Double', B) Used ToNumber function

2. Trim leading zeros and / descriptive texts : Used ToNumber function

3. Remove 'ID' from the end : A) Wrote conditional function IF Right([ID], 2)='ID' THEN Left([ID], Length([ID])-2) ELSE [ID] ENDIF; B) Used TrimRight

4. Add 'SC' and remove anything after 8 characters : Wrote conditional function IF Length([Safety Code])>8 THEN Left([Safety Code], 😎 ELSE IF Length([Safety Code])=6 THEN 'SC'+[Safety Code] ELSE [Safety Code] ENDIF ENDIF

Looking forward to better approaches.

Regards

KD

[terry10]

So many different ways to clean up this data. Good practice.

[Mélanie]

Funny challenge !