Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHi 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
Great challenge to practice using the Formula tool!
Here's a solution