it turns out it is not working correctly. It is adding all the zeros to the front and not to the 2 parts.

Column 1 - 12345 should be 6 characters 012345

Column 2 - 1 should be 3 characters 001.

The code you showed in returning

000123451 not 012345001 as I am trying to get.