Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Very Interesting Problem, How Can I Do It Better ?
RegEx is your friend, I recommend my fellow Alteryxers to check this out:
You can use GitHub to sign in
My regexs to solve were:
.*(\d{4}).*
(0*)(\d*)
and strip out the 1st token, just take the 2nd token
(ID)$
strip out the string "ID" from every line
\w{8}
this needs to be paired with a formula before:
IF Length([Safety Code])<8 THEN "SC"+[Safety Code] ELSE [Safety Code] ENDIF