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