Update AD users employeenumber based on csv file

The below script should take any length of employeeID, which is less than the required number of digits, and add a leading digit, before adding the prefix character.

$Prefix = "A"
$RequiredLength = 6
$LeadingChar = 0

$EmployeeID = "1234567"
$EmployeeNumber = ""

$CurrentLength = $EmployeeID.length

If($CurrentLength -gt $RequiredLength)
{
    Return "Employee Identity longer than required length"
}
ElseIf($CurrentLength -lt $RequiredLength)
{
    $LeadingZeroRequired = $RequiredLength - $CurrentLength

    Do
    {
        $EmployeeID = [string]::Format("{0}{1}",$LeadingChar,$EmployeeID)
        $LeadingZeroRequired--

    } While ($LeadingZeroRequired -ne 0)
}

$EmployeeNumber = [string]::Format("{0}{1}",$Prefix,$EmployeeID)

$EmployeeNumber

The below script should take any length of employeeID, which is less than the required number of digits, and add a leading digit, before adding the prefix character.

$Prefix = "A"
$RequiredLength = 6
$LeadingChar = 0

$EmployeeID = "1234567"
$EmployeeNumber = ""

$CurrentLength = $EmployeeID.length

If($CurrentLength -gt $RequiredLength)
{
    Return "Employee Identity longer than required length"
}
ElseIf($CurrentLength -lt $RequiredLength)
{
    $LeadingZeroRequired = $RequiredLength - $CurrentLength

    Do
    {
        $EmployeeID = [string]::Format("{0}{1}",$LeadingChar,$EmployeeID)
        $LeadingZeroRequired--

    } While ($LeadingZeroRequired -ne 0)
}

$EmployeeNumber = [string]::Format("{0}{1}",$Prefix,$EmployeeID)

$EmployeeNumber

Thanks Stu for thw quick answer.

I modify the workflow by editing the script in the updating rules on the source side

and the result before comitting is the following:

For all users with employeeID less than 6 digits or more it would modify the EmployeeNumer to display "Employee Identity longer than required length"

I am thinking maybe there's a way to divide the workflow in 2, one for those with less than 6 digits in EmployeeId and one another one for 6 digits ?

Can you share the script you used in your Workflow?

If its actually outputting "Employee Identity longer than required length" them it might be processing an entry there the existing length of the source attribute is longer than required. It would probably be best in that instance to just not update it.

Also if you have are coying the value from Attribute1 (EmployeeNumber) and putting it into Attribute2 (EmployeeID), I'd validate both sides, IE:

If the length of EmployeeNumber is 6 of less, but not null, copy across to EmployeeID adding leading character to make it 6 character, then prefix your A value.

If the length of the EmployeeNumber is 7 or more, this is not valid (that I'm aware of), so don't bother updating the EmployeeID.

If the length of employeeNumber is 0., dont update EmployeeID.

Hope this help.