Text Transformations

Text transformations can be used to create custom strings based off an individual user’s properties. For example, the text transformation `LEFT(String, Num of Left Char)` can be used in conjunction with the field variables %givenName% and %surname%, to output a userPrincipalName consisting of the first 3 letters of the givenName, followed by the surname and domain. To achieve this, the original text transform is modified with the field variables, as shown below:

Note: Text transformations are denoted by back ticks (`) which are not advised for use in OneSync to minimize errors.

The following is a list of provided text transformations:

• `GRADE_TO_YOG(String)`: calculates the graduation year (Note: Kindergarten = "0")
• `GRADE_TO_YOG_ALT(String, Year of Grad)`: calculates the year of enrollment
• `INDEX_OF(Search In String, Search For String, Start Index)`: returns the index number of a substring within a string, searching at and after the starting index
• `IS_EMPTY(Value If Not Empty, Value If Empty)`: returns one of two values based on whether a field is empty; can be used for fields that do not always have values, e.g. middle name
• `LEFT(String, Num of Left Char)`: selects the left characters of a string based on the provided number
• `LOWER_CASE(String)`: change string to all lower case
• `PROPER_CASE(String)`: change first letter of string to uppercase, and the rest lower case
• `REQUIRE(String)`: turns an optional field into a required field and will throw an exception if that optional field is left blank
• `RIGHT(String, Num of Right Char)`: selects the right characters of a string based on the provided number
• `STRIP(String, Remove String, Remove String, ...,)`: removes a desired character or substring from a string
• `SUBSTRING(String, Start Index, Length)`: selects part of a string according to the desired starting index and desired length of the part
• `TRIM_AFTER_SPACE(String)`: selects all of a string before the first space, trims everything after the first space
• `UPPER_CASE(String)`: change string to all uppercase