MapForce includes a large number of readily available built-in functions that you can add to the mapping as described below. For reference to all available built-in functions, see Function Library Reference.
To use a function in a mapping:
1.Select the transformation language (see Selecting a transformation language). Note that the list of available functions depends on the selected transformation language.
2.Click the required function in the Libraries window and drag it to the mapping area. To filter functions by name, start typing the function name in the text box located in the lower part of the window:
Alternatively, you can also quickly add a function to the mapping as follows:
1.Double-click anywhere on the empty area of the mapping and start typing the function name. A combo box appears with the same functions as in the Libraries window, filtered by the text you entered. To see a tooltip with more details about each function, select any function in the list.
2.Select the required function, and press Enter to add it to the mapping. To close the combo box without selecting a function, press Escape, or click anywhere outside the box.
Note: Using the "double-click" alternative way described above, you can also add user-defined functions to the mapping.