This reference section describes the MapForce built-in functions available in the Libraries window. The functions are organized by library. The availability of function libraries in the Libraries window depends on the transformation language you choose for your mapping. To find out more about the list of available transformation languages, see this topic.
The information about the compatibility of functions and transformation languages is provided in the subsections below.
The lists below summarize the compatibility of core functions with transformation languages.
•avg, max, max-string, min, min-string: XSLT 2.0, XSLT 3.0, XQuery 1.0, C#, C++, Java, Built-In;
•count, sum: all transformation languages.
•boolean, string, number: all transformation languages;
•format-date, format-dateTime, format-time: XSLT 2.0, XSLT 3.0, C#, C++, Java, Built-In;
•format-number: XSLT 1.0, XSLT 2.0, XSLT 3.0, C#, C++, Java, Built-In;
•parse-date, parse-dateTime, parse-number, parse-time: C#, C++, Java, Built-In.
All the file path functions are compatible with all the transformation languages.
The auto-number function is available for all the transformation languages.
The logical functions are compatible with all the transformation languages.
•add, ceiling, divide, floor, modulus, multiply, round, subtract: all transformation languages;
•round-precision: C#, C++, Java, Built-In.
•is-xsi-nil, local-name, static-node-annotation, static-node-name: all transformation languages;
•node-name, set-xsi-nil, substitute-missing-with-xsi-nil: XSLT 2.0, XSLT 3.0, XQuery 1.0, C#, C++, Java, Built-In.
The QName functions are compatible with all the transformation languages except for XSLT1.0.
•exists, not-exists, position, substitute-missing: all transformation languages;
•distinct-values, first-items, generate-sequence, item-at, items-from-till, last-items, replicate-item, replicate-sequence, set-empty, skip-first-items: XSLT 2.0, XSLT 3.0, XQuery 1.0, C#, C++, Java, Built-In;
•group-adjacent, group-by, group-ending-with, group-into-blocks, group-starting-with: XSLT 2.0, XSLT 3.0, C#, C++, Java, Built-In.
•concat, contains, normalize-space, starts-with, string-length, substring, substring-after, substring-before, translate: all transformation languages;
•char-from-code, code-from-char, tokenize, tokenize-by-length, tokenize-regexp: XSLT 2.0, XSLT 3.0, XQuery 1.0, C#, C++, Java, Built-In.
All the BSON functions are compatible only with Built-In.
The db functions are compatible with C#, C++, Java, Built-In.
The edifact functions are compatible with C#, C++, Java, Built-In.
The lists below summarize the compatibility of lang functions with transformation languages.
The lang | datetime functions are compatible with C#, C++, Java, Built-In.
The functions read-binary-file and write-binary-file are compatible only with Built-In.
The create-guid function is available for C#, C++, Java, Built-In.
The lang | logical functions are available for C#, C++, Java, Built-In.
The lang | math functions are available for C#, C++, Java, Built-In.
The lang | QName functions are compatible with C#, C++, Java, Built-In.
•charset-decode, charset-encode: Built-In;
•match-pattern: C#, Java, Built-In.
•capitalize, count-substring, empty, find-substring, format-guid-string, left, left-trim, lowercase, pad-string-left, pad-string-right, repeat-string, replace, reversefind-substring, right, right-trim, string-compare, string-compare-ignore-case, uppercase: C#, C++, Java, Built-In.
The mime functions are available for Built-In only.
The xbrl functions are compatible with C#, C++, Java, Built-In.
The xlsx functions are compatible with XSLT 2.0, XSLT 3.0, C#, Java, and Built-In.
All the xpath2 functions are compatible with XSLT 2.0, XSLT 3.0, and XQuery 1.0.
All the xpath3 functions are compatible only with XSLT 3.0.
The lists below summarize the compatibility of xslt10 functions with transformation languages.
•local-name, name, namespace-uri: XSLT 1.0, XSLT 2.0, and XSLT 3.0.
•lang, last, position: XSLT 1.0.
•generate-id, system-property: XSLT 1.0, XSLT 2.0, and XSLT 3.0.
•current, document, element-available, function-available, unparsed-entity-uri: XSLT 1.0.