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
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
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
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
