Hi guys,
I have a column which contains some id (only numbers). the number of characters can vary eg: 012345 or 01234 or 1234.
I order to upload my output to a server i need this column's length to have exactly 11 characters.
So i Would need 012345 to become 00000012345, 01234 to become 00000001234, 1234 to become 00000001234
Any idea?
Thanks in advance
Solved! Go to Solution.
You can use the padleft function. Make sure your column is a string with length of 11 characters.