Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere's my solution:
Love the tokenizer! Sounds like a super hero 🙂
Now off to browse everyone elses solutions to see if there was some two tool solution which I skipped... Is there an issue with some versions processing fixed decimal types? I know there was a question on the forum a few weeks back from a user who couldn't get two decimal places automatically using a fixed decimal with a detail of 2. My version of Designer seems to have the same issue so I had to manually add the extra zero where applicable.
Found an elegant 3 step solution for this one!
I struggle to find a use-case where needing to do this would actually be beneficial. However, good use of the "Padleft" function.
learn about Padleft function