My first post/question.
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!
Solved! Go to Solution.
Subfield(ProductId,'-',1)&Subfield(ProductId,'-',2)&num(Subfield(ProductId&'-0','-',3),'000') as Test;
LOAD * Inline [