Purpose: This method is used to convert all characters of a given string value to remove capitalization. This can be helpful prior to comparisons as well as in other situations which require lowercase wording. The return value is a new string containing the lowercase string.
Syntax: lower(value)
Example: The customer wants the target DisplayName to be all in lowercase.
Target Attribute : DisplayName
Value : lower(S.DisplayName)
Condition : Null
Purpose: This method swaps all instances of one target string within a search string with a replacement string. Returns a new string created from given input string source with all instances of string value exchanged for instances of string replacement. If string source does not contain any instances of string value, the result will be the same as source. Note, the resulting string may be longer or shorter than the source string.
Syntax: replace(source, value, replacement)
Example: The following expression will replace part of the old company name with the new one. The goal is to replace "RedFish" in the source Company attribute with "BlueFish" in the target. If the source is "RedFishHotels" the new value in the target will be "BlueFishHotels".
Target Attribute : Company
Value : replace(S.Company, "RedFish", "BlueFish")
Condition : Null
Purpose: This method evaluates whether the given string value is a prefix of the given string source. Returns True if source begins with value and False otherwise.
Syntax: starts(source, value)
Example: The following will set CustomAttribute10 to "NA" if the source Location attribute begins with "United States"
Target Attribute : CustomAttribute10
Value : "NA"
Condition : starts(S.Location, "United States")
Purpose: This method removes leading and trailing spaces from given string value. Note that this does not remove other whitespace characters besides space. The return value is a copy of the input string value with no leading or trailing spaces.
Syntax: trim(value)
Example: "BlueFishHotels" becomes "BlueFishHotels"
Target Attribute : Company
Value : trim(S.Company)
Condition : Null
