Version 2 with the new data sets:
[ID], 'ID$', ''
if Length([Safety Code]) <= 6 then
'SC' + [Safety Code]
left([Safety Code], 8)
Here's my solution round 2:
For all of the new ones that wonder how come there isn't more solutions, or why some of the old solutions seems differently, then it is because all submitted solutions that contained data, was removed from this challenge due to technical reasons.
But all though I have previously made this one before, it actually was a fresh re-take of this "old" challenge.
So instead of "just" resubmitting my old solution, I made this one again, and I can see, that I have learned a lot just in that brief time since I last did it - thanks to the team behind the weekly challenges