Challenge #35: Data Cleansing Practice

[cswanson21x]

My Solution:

[mbarot]

Here's my solution 

1) Removing leading zeros

- Used the select tool to convert the string to integer

2) Trim leading zeros and/or descriptive text at the end

- Text to columns split on the colon delimiter

- Select tool used to choose the required columns and for renaming purpose.

3) Remove data values that end with ID

- Applied the formula tool using the TrimRight([ID],"ID")

4) If more than 8 chars then remove anything after 8. And, if only 6 chars add SC in the beginning.

- Text to column separated by colon delimiter 

- Formula tool applied using "SC" + [1]

- Select tool used to choose the required columns and for renaming purpose.

[grazitti_sapna]

Hi,

Here is my take on this challenge.

[ldean]

Here is my solution.

[BalOates]

Just used a single formulae tool for each of these. 

[thaodinh95]

Here is my solution! I was hoping to use RegEx tool for the 2nd one but end up using Text to Column tool instead.

[DaisyJones]

Here is my Solution

Spoiler

 

[jags91]

 My Solution

[hannahc]

Here is my solution!

[KOON]

here it is