There are five mapping function types: String, Mathematical, Miscellaneous, Binary Data and Date.
The mapping functions can be displayed by clicking the Functions tab. Mapping functions are divided into the following categories:
String Functions | Definition |
---|---|
Align Center | Centers a string within the specified padding string. |
Align Left | Places a string inside a padding string starting from the leftmost character. |
Align Right | Places a string inside a padding string ending with the rightmost character. |
Concatenate | Joins all the parameter strings into a single string. |
Format Number | Returns a string that is a number formatted to fit the specified pattern. |
Length | Determines the number of characters in the parameter. |
Lowercase | Converts all uppercase English characters to lowercase characters. |
Padding String | Returns a padding string of the specified length and characters. |
Replace | Replaces individual characters with other individual characters. |
Starts With | Determines whether the first parameter begins with the characters in the second parameter. |
Substring | Extracts a portion of the parameter based on the specified character placement. |
Substring After | Extracts all the characters in a string starting after the first occurrence of a specified substring (one or more characters) through the end of the string. |
Substring Before | Extracts all the characters in a string from the beginning to the first occurrence of a specified substring (one or more characters). |
Trim | Trims all leading and trailing space from the parameter and normalizes all space within the parameter. |
Uppercase | Converts all lowercase English characters to the corresponding uppercase character. |
Mathematical Functions | Description |
---|---|
Absolute Value | Determines the absolute value of a parameter. |
Add | Adds all parameters. |
Average | Determines the average value of the numeric nodes or sets of nodes in parameters. |
Ceiling | Rounds the parameter up to the next closest integer. |
Count | Counts the number of nodes in all the nodes or sets of nodes in parameters. |
Divide | Returns the quotient of the first parameter divided by all the subsequent parameters. |
Floor | Rounds the parameter down to the next closest integer. |
Maximum | Determines the highest value in the numeric nodes or sets of nodes in parameters. |
Minimum | Determines the lowest value in the numeric nodes or sets of nodes in parameters. |
Modulo | Determines the remainder from dividing the first parameter by all subsequent parameters. |
Multiply | Returns the product of all parameters. |
Round | Rounds a number to the closest integer. |
Subtract | Returns the difference of the first parameter less all subsequent parameters. |
Sum | Adds all the numeric nodes or sets of node in parameters. |
Miscellaneous Functions | Description |
---|---|
Boolean | Evaluates the parameter and returns either true or false depending on the data type of the input. |
CopyOf | When the name of the source node matches the passed in value, this function copies the entire contents of the source node (the entire subtree of the source node including all children) to the destination node. |
Not | Returns true if the parameter evaluates as false. Returns false if the parameter evaluates as true. |
Number | Changes the data type of the parameter to number. |
Position oh | Determines the index to the current node within the set of its siblings. |
String | Changes the data type of the parameter to string. |
Functions for Binary Data | Description |
---|---|
Cast From Base64Binary function | Casts from the XML Schema data type: xs:base64Binary to the XML Schema data type: xs:string. |
Cast From HexBinary function | Casts from the XML Schema data type: xs:hexBinary to the XML Schema data type: xs:string. |
Cast To Base64Binary function | Casts from the XML Schema data type: xs:string to the XML Schema data type: xs:base64Binary. |
Cast To HexBinary function | Casts from the XML Schema data type: xs:string to the XML Schema data type: xs:hexBinary. |
Date Functions | Description |
---|---|
Get Current® Date and Time function | Returns the current date and time (with the local timezone) as a XML Schema data type: xs:dateTime. |
Get Current Date function | Returns the current date (with the local timezone) as a XML Schema data type: xs:date. |
Get Current Time function | Returns the current time (with the local timezone) as a XML Schema data type: xs:time. |
Read Date String function | Converts a string (that contains a date and time) to the XML Schema data type: xs:dateTime |
Format Date String function | Converts a XML Schema data type: xs:dateTime to a string in the format defined by the second parameter. |