Challenge #35: Data Cleansing Practice

[Ozzy_Campos]

Resubmitting with new data. 

[abinder]

solution attached

[Parul_Kapoor]

Here is the solution.

[ctrl_kudorje]

Here's to challenge 35. I mainly used formulas here to help me get the right values. I played with the left and length functions to help me get the correct number of characters from the field. I do see a lot of improvements that I can make with regex and that's in my goals to learn.

[rachelgatto]

Solved. 

[dsmdavid]

Reposting after this:

Can't help but wonder. What hidden jewels were in the data?

Spoiler

[Kirti1]

Hello,

Here is completed solution please find attached workflow.

[wdavis]

Challenge completed. A slight variation across a few of the other solutions

Spoiler

[Carlithian]

Another one down

[Kenda]

Spoiler