Challenge #35: Data Cleansing Practice

[Jeremy]

My solution attached.  Removing leading zeros seems pretty straightforward if you just convert it to a number.  Is there something else we're supposed to do with leading zeros?

[axelsteenberg]

My solution for the challenge.

[abhijeet_ghosh]

Here is my submission:

1. Here I have replaced the Zero using this formula: Replace([Field1], "0", "")

2. Here I have first used regex (\<0*) and then used Text to Column to split the number and the text.

3. Here I have used regex (ID$) to remove the word ID from the end

4. Here I have used formula to accomplish the result.

Formula:
IF Length([Safety Code])<8 THEN "SC" + [Safety Code] ELSE Left([Safety Code], 8) ENDIF

[Powerhouse_21]

Spoiler

[jhaines]

Good review of data prep tools. Tried to use as few tools as possible.

Spoiler

[SkomantasTamulaitis]

Solved!

Spoiler

[roycephillipsjr]

here is mine

[Liam_Bremner]

my solution

[m-wolters]

My solution