I'm loading data from multiple sources, and the ProductId is formatted in different ways.
In most sources its formatted like below (goal):
But in some sources it looks like below (needs to be formatted):
So first of all I need to get rid of the " - ", but that I can solve with substitute. But what I'm struggling with is how I deal with adding the zeros before the last number(s), making them all the same length.
Any ideas on how to solve this would be greatly appreciated!