Normalize first and last name

Question

We are using a custom form a property patterns to create specific contract resource accounts. We would like to know how to normalize the first and last name fields when the manager is entering them.
(ex. TOM --> Tom or tom --> Tom)

Answer 1

Hello,

There is no possibility to achieve what you need using Property Patterns. As a workaround, you can use the PowerShell script below executed by a Business Rule triggering Before Creating a User.

$propertiesToCheck = @("givenName", "sn", "name", "displayName") # TODO: modify me

function FixString ($string)
{
    return $string.SubString(0, 1).ToUpper() + $string.SubString(1).ToLower()
}

foreach ($propertyName in $propertiesToCheck)
{
    # Get value
    $value = $Context.GetModifiedPropertyValue($propertyName)
    if ([System.String]::IsNullOrEmpty($value))
    {
        continue
    }

    # Converting first character of a value to uppercase
    if ($value -match " ")
    {
        $valueParts = $value.Split(" ") | %%{FixString $_}
        $value = [System.String]::Join(" ", $valueParts)
    }
    else
    {
        $value = FixString $value
    }

    # Update property
    $Context.SetModifiedPropertyValue($propertyName, $value)
}

Comments

Thank you this worked perfectly. Great job and quick turnaround.

---

Sorry to resurrect this but everything seems to be working except the full name field when I set this up.

I have it set to run before user creation. Any ideas?

Screenshot:

---

Hello,

Most probably, this happens because the Full Name property was not included into the $propertiesToCheck array. You need to add cn to the array, which is the LDAP name of the Full Name property.