Challenge #35: Data Cleansing Practice

[BeginnerMindset]

Done

[jeremyhaber814]

Challenge # 35

[ptmyen]

my solution 🙂

[Eilean_]

RT

[Salvatore_Miseo]

Hi everyone
Attached my solution

In solving the exercise I used only formulas:

Exercise (1)
ToNumber ([Field1])

Exercise (2)
ToNumber (Left ([Field1], FindString ([Field1], ":")))

Exercise (3)
TrimRight ([ID], "ID")
Exercise (4)
IF Length ([Safety Code])> 8 THEN
Left ([Safety Code], 😎
ELSE
IIF (Length ([Safety Code]) <= 6, "SC" + [Safety Code], [Safety Code])
ENDIF

[CairstineDK]

Find my attached solution 🙂

[aluthra]

Solved!

[DeanWest]

Great challenge to practice using the Formula tool!

Spoiler

[Daje7146]

Here's a solution

Spoiler