Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHi MB,
The error is in the syntax of the PadLeft function. You should have accounted for the length that the String needs to be once you insert the prefix character. The below modified code should work for you. Hope this helps!
IF Length([Safety Code]) = 6
THEN PadLeft(PadLeft([Safety Code], 7, "C"), 8, "S")
ELSE [Safety Code]
ENDIF
My Solution -