I have values in a text column that are as follows:
000_100
100_200
...
1000_1100
1100_1200
I want it to read:
0000_0100
0100_0200
...
1000_1100
1100_1200
I want all values to have the same number of characters, for example 9. The numbers in the hundreds separated by the "_" need a "0" infront for this to be accomplished. I saw that I can use zfill to add a "0" to the beginning, but is there a way to specify where to put a second "0"?