Today, I found myself with a small dilemma. I needed to do a user data extract from Active Directory, massage the data a bit, spit out a CSV, and the upload the CSV to a piece of software we use. Easy, simple, no problem….until the software wasn’t putting people into the places they were supposed to go. Damn it!
After a little trouble shooting, we figured out that the field we were pulling from AD (the “office” field) to sort people in the software, would not accept anything with a single digit. So for example offices 20, 33, and 23 would get sorted perfectly fine. Anything with a single digit like offices 3, 5, and 7, would not get sorted.
Basically, I needed to pad anything that was only one character, by putting a zero in front of it. So an office number like “2” would become “02”. Powershell makes this really easy to do . For example:
1 2 3 | $office_number = "2" $padded_office_number = $office_number.Padleft(2, "0") $padded_office_number |
Easy peasy.
So, breaking down the .padleft(2, “0”) a bit. The first number in the parenthesis, the number 2, is how far you want to pad out to the left, and the zero in the quotes in my example, is the character you want to pad with. It could be any character, not just a number.
.padright() works exactly the same as .padleft()
By day, I’m a systems admin for a medium size company in the Pacific Northwest.
By night, I’m a blogger, gamer, and all around general nerd.
If you found one of my articles useful, please consider supporting this site!
Monero: 48PxwMvbwoB2M86sHespLBKcSL9cWxrnJDmga9XshSqRP1joykRNpKkDGUz4ohhxD1bMH92poMyZWBBqkPmQ2bHpLP4EDnz
Bitcoin: bc1qc0fyze8x9lxp42x5p3zpry6f0lsr6l5pgq4jkh
Ethereum: 0xc613cBc79Ea4a84AE5538ec3321E214363305121