Challenge #35: Data Cleansing Practice

[DennisK]

Attached solution

[mattnason1]

Pretty fun.

[katiematkin93]

Spoiler

[gabrielamitache]

My solution: 

[dYoast]

Somewhat simple, but it still makes you think.

[dbAlfa]

Attached my solution.

[Amy_smart]

Here is my solution.

[gabrielpereira]

Solution

[kishorerabhinav]

My solution to this challenge:

It was pretty straightforward and mainly focused on using different trim functions for the string data types.

[cooperreynolds]

Solution. Can anyone explain what exactly the RegEx replace tool is doing when I use the formula (ID$)? Thanks.