Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello, I've had a look around and can't find the answer to my specific issue.
I have some source data where one of the columns contains a number which can typically be either one, two or three characters. In the output I want all those values to be six characters long. So if the source contains two, I want to add four leading zeros, if the source contains three, I want to add three leading zeros, etc. I'm not sure how to do this?