Mapping functions overview

There are seven mapping function types: String, Mathematical, HTTP Header, Miscellaneous, Binary Data, Date, and Security functions.

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 that is 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 that is 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.
HTTP Header functions Description
Extract HTTP Header Field function Extracts a string with a specified delimiter. It can also be used to further extract strings from HTTP headers.
Extract URI Path function Extracts a URI from the HTTP header's URI string.
Extract Query Parameter function Extracts a query string from the HTTP header's URI string.
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 an XML schema data type: xs:dateTime.
Get Current Date function Returns the current date (with the local timezone) as an XML schema data type: xs:date.
Get Current Time function Returns the current time (with the local timezone) as an 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 an XML schema data type: xs:dateTime to a string in the format that is defined by the second parameter.
Security functions Description
AES Encrypt function Encrypts the fields and content using the Advanced Encryption Standard (AES) algorithm.
AES Decrypt function Decrypts the fields and content using the Advanced Encryption Standard (AES) algorithm.



Feedback | Notices


Timestamp icon Last updated: Tuesday, 27 September 2016


http://pic.dhe.ibm.com/infocenter/wci/v7r0m0/topic/com.ibm.wci.doc/ref_Mapping_Function_Overview.html