Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere is my submission:
1. Here I have replaced the Zero using this formula: Replace([Field1], "0", "")
2. Here I have first used regex (\<0*) and then used Text to Column to split the number and the text.
3. Here I have used regex (ID$) to remove the word ID from the end
4. Here I have used formula to accomplish the result.
Formula:
IF Length([Safety Code])<8 THEN "SC" + [Safety Code] ELSE Left([Safety Code], 8) ENDIF
Good review of data prep tools. Tried to use as few tools as possible.
Solved!