Challenge #35: Data Cleansing Practice

[rajatsadan]

Thanks @TheOC for helping out!!

[deepakbokaria]

スポイラ

Spoiler

Here is my take on this challenge

[OwenBData]

Solution(s):

スポイラ

[sunny430]

My solution:

[kstrakova]

Fun exercise for beginners. Solution worfklow here

[SWalker]

Core prep!

[heystephania]

This was a great way to practice using the formula tool. 

[Tokimatsu]

Solved.

スポイラ

1. 
tonumber([Field1])

2. 
ToNumber(REGEX_Replace([Field1], "(\d+)\.+", "$1"))

3.
TrimRight([ID],"ID")
// REGEX_Replace([ID], "(.*?)I*D*$", "$1")
// REGEX_Replace([ID], "(.+)ID$", "$1")

4.
REGEX_Replace([Safety Code], ".*(C\d{5}).*", "SC$1")
// "SC"+right(Left([Safety Code], 8),6)

[Per]

Done!

[wardboston]

スポイラ

Problem #1

Problem #2

Problems #3&4