Challenge #35: Data Cleansing Practice

[ishizuka]

Here is my solution

[Laurap1228]

Here is my solution.

Spoiler

Formulas for the 4 tasks:

1. Remove leading zeroes
TrimLeft([Field1],"0")

2. Trim leading zeroes and/or descriptive text at the end
TrimLeft([Field1],'0')
plus Tokenize Regex (\d+).*

3.If the data value ends with ID, remove the ID
IF Right([ID], 2)="ID" THEN Replace([ID], 'ID', '') ELSE [ID] ENDIF

4.If more than 8 chars, remove anything after 8. If only 6, add “SC” to the front.
PadLeft(Left([Safety Code], 8), 8, 'SC')

[Gbenga_Opadiji]

solution

[mike_w]

my approaches

[RNG]

.

[VenkataP]

Here is another solution..

[Harkamal]

My solution .

[KirstyHarvey]

All solved using Data Cleanse or Formula tool

Only 4 questions in the challenge where some have answered a 5th??? Not sure if I'm missing something!!

[gradyg19]

Loved this exercise. Struggled with the last part though. Surely there was an easier way to do it than what I did. Anyway, cheers.

[pagrawal]

Spoiler

Spoiler