Hi Sean. Great tip! For left padding, I simply use the Format function. So "Format("123", "00000")" returns "00123". However, I have never needed right padding, so the method you showed will definitely come in handy if I ever need it.
@seanmackenziedataengineering5 ай бұрын
Great tip! That's a good one. I think lots of people also just concatenate the string "00000" or "XXXXX" or whatever, then get Right/Left.
@tuffley21755 ай бұрын
📝 Is it possible to pad with random numbers and unique!!!! ( when I ask for a rise I get left padding increase😢)
@seanmackenziedataengineering5 ай бұрын
I see! That's a great idea - nice idea to use random numbers but that would be another video (cool one). We would look into a random function for that 🛠