Challenge #35: Data Cleansing Practice

[TonyaS]

Spoiler

[DfloDBDB]

This is my solution. I am not too sure of the last one but it yield the result.

[drmickelsen]

Seems to produce the answer with minimal steps

[jeng]

Spoiler

[harish_ramkumar]

Hello,

Kindly find my solution below.

Thank you

-Harish

[apabonok]

Hi. This is my solution. 

About 3rd point (If the data value ends with ID, remove the ID), I have done 1 additional output without ID word.

[Snare]

Solutions below:

Spoiler

1. Select statement to convert string to number - automatically drops leading 0.

2. Data Cleansing (it is "Data Cleansing Practice" after all) to remove anything except numbers then, same trick as 1 above, Select.

3. Formula using TrimRight to remove trailing ID.

4. Formula using nested IF to only keep 8 characters AND to append leading SC for strings equal to 6 characters.