On Demand Migration Current - Active Directory - Directory Sync Advanced Mapping Guide

trunc

• Purpose: This method returns a string which contains only the given length number of characters starting from the beginning of the given string source. Note, if length is greater than the length of string source, the result will be identical to string source.

• Syntax: trunc(source, length)

• Example:  You want to use firstName and lastName to build the sAMAccountName but are limited to 20 characters.

  Target Attribute    : sAMAccountName

  Value        : trunc(S.givenName+S.sn, 20)

  Condition    : Null

upper

• Purpose: This method is used to convert the characters of a given string value to all capital letters. This can be helpful prior to comparisons as well as in other situations which require uppercase wording. The return value is a new string containing the uppercase string.

• Syntax: upper(value)

• Example: The customer wants the target DisplayName to be all in uppercase.

  Target Attribute    : DisplayName

  Value        : upper(S.DisplayName)

  Condition    : Null

index

• Purpose: This method returns the location of the beginning of the first instance of given string value within given string source. The position begins counting from 1 for the first character. Returns -1 if no instance of string value is found in string source.

• Syntax: index(source, value)

• Example: You need to use the left part of the UPN as the DisplayName in a new environment. The following expression will find the location in the UPN string of the ‘@’ and then take all characters to the left of that.

  Target Attribute    : DisplayName

  Value        : trunc(S.userPrincipalName, index(S.userPrincipalName, "@") - 1)

  Condition    : Null

Prefix

• Purpose:  The prefix function will add the prefix specified to the value specified ONLY if that value is NOT null or an empty string.

• Syntax: prefix(value,prefix)

• Example:

  Target Attribute    : used in combination with other functions to create a proxyaddress

  Value        : prefix(Result("mail"), "SMTP:")

  Condition    : Null