Challenge #35: Data Cleansing Practice

[H_a_n_g_C_h_e_n__x3]

Nice recap

[Gmajid786]

My solution, not great with regex like in the solution so just stuck with the formula tool

[AmanDevrath]

My Solution :

Spoiler

[tdiipo]

My solution

Spoiler

[AshaDaniels]

Spoiler

 

[Matthias_Albert]

First time I'm feeling like I'm close to an optimal solution. Also my first outing to regex using alteryx.

Spoiler

 

[supriyamb83]

learnt to clean data using various tools like RegEx , formulae , select , text to clumns 

[GabrielaTudor]

Spoiler

[Teïlo]

My solution for this challenge (:

[wbaliwag]

Here's my solution