First - I used a formula tool to remove zeroes.
Second - Used data cleanse to remove letters and punctuation. Then I used formula tool to TrimLeft any "00". Then Joined back to original dataset to match output
Third - Used formula tool to TrimRight "ID" from end of strings
Fourth - Used one formula tool, combining length and substring, exact formula: if Length([Safety Code]) > 8 then Substring([Safety Code],0,8) elseif length([Safety Code]) = 6 then "SC" + [Safety Code] else [Safety Code] endif