Form Validation

Question

Hi

We've run into an issue a couple of time recently where people creating new starters are using copy and paste, but including whitespace at the beginning or end of the users names.

I've tried to mitigate this by adding the following to a script which is run before the user is created, but all I get is an error

#Remove leading and trailing whitespace from First, Last and Full name
$Properties = @("firstname","lastname","fullname")
foreach ($propertyName in $Properties) {
    $value = $Context.GetModifiedPropertyValue($propertyName)
    $removedWhitespaceValue = $value.trim()
    if ($value -ne $removedWhitespaceValue) { 
        $Context.LogMessage("Removing whitespace for '$propertyName'.", "Notification")
        $Context.SetModifiedPropertyValue($propertyName, $removedWhitespaceValue) 
    }
}

Is there an easy way to add validation to the fields to and remove any whitespace?

Thanks

Answer 1

Hello,

Have a look at the following tutorial: https://www.adaxes.com/tutorials_Simpli ... Script.htm. You need Example 5: Automatically remove spaces from the username.

Comments

Thanks very much, I'll work through that.

---

Hi

Turns out I was close with my first script, the issue was the attribute names I was using.
To my mind, the following is cleaner and easier to manage than duplicating the same code for each property.
This also allows for the cleanup of whitespace from the beginning and end of the users full name.

#Remove leading and trailing whitespace from First, Last and Full name, SAMAccountName and UserPrincipleName
$Properties = @("givenName","sn","cn","samAccountName","userPrincipalName")
foreach ($propertyName in $Properties) {
    #Get the property value
    $value = $Context.GetModifiedPropertyValue("$propertyName")
    #Trim the white space from the beginning and end
    $trimmedValue = $value.trim()
    $Context.LogMessage("Checking $propertyName for whitespace", "Information")
    #If the original and trimmed values don't match, there must be whitespace
    if ($value -ne $trimmedValue) {
        $Context.LogMessage("Removing whitespace for '$propertyName'.", "Information")
        #Write the trimmed value back to the property.
        $Context.SetModifiedPropertyValue("$propertyName", $trimmedValue) 
    }
}

Hope this helps someone :)

Matt

---

We faced the same issue, and we are using a regex to deny starting/ending white chars:

^[^\s].*[^\s]$