My Manager has tasked me with creating an automated solution that reads a CSV file column that contains user IDs and will remove unneeded two digits at the end of the User ID and then add this ID to the email section of the user’s AD profile. These two digits are always zeros. So for instance, John Smith could have a User ID of 12345600 and I need a way of removing those last two zeros using PowerShell. Also, the User IDs may be different lengths.
Any help on this is much appreciated.