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.
core functions
The lists below summarize the compatibility of core functions with transformation languages.
core | aggregate functions
•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.
core | conversion functions
•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.
core | file path functions
All the file path functions are compatible with all the transformation languages.
core | generator functions
The auto-number function is available for all the transformation languages.
core | logical functions
The logical functions are compatible with all the transformation languages.
core | math functions
•add, ceiling, divide, floor, modulus, multiply, round, subtract: all transformation languages;
•round-precision: C#, C++, Java, Built-In.
core | node functions
•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.
core | QName functions
The QName functions are compatible with all the transformation languages except for XSLT1.0.
core | sequence functions
•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.
core | string functions
•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.
bson functions (MapForce Enterprise Edition only)
All the BSON functions are compatible only with Built-In.
db functions (MapForce Professional and Enterprise editions)
The db functions are compatible with C#, C++, Java, Built-In.
edifact functions (MapForce Enterprise Edition only)
The edifact functions are compatible with C#, C++, Java, Built-In.
lang functions (MapForce Professional and Enterprise editions)
The lists below summarize the compatibility of lang functions with transformation languages.
lang | datetime functions
The lang | datetime functions are compatible with C#, C++, Java, Built-In.
lang | file functions
The functions read-binary-file and write-binary-file are compatible only with Built-In.
lang | generator functions
The create-guid function is available for C#, C++, Java, Built-In.
lang | logical functions
The lang | logical functions are available for C#, C++, Java, Built-In.
lang | math functions
The lang | math functions are available for C#, C++, Java, Built-In.
lang | QName functions
The lang | QName functions are compatible with C#, C++, Java, Built-In.
lang | string functions
•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.
mime functions (MapForce Enterprise Edition only)
The mime functions are available for Built-In only.
xbrl functions (MapForce Enterprise Edition only)
The xbrl functions are compatible with C#, C++, Java, Built-In.
xlsx functions (MapForce Enterprise Edition only)
The xlsx functions are compatible with XSLT 2.0, XSLT 3.0, C#, Java, and Built-In.
xpath2 functions
All the xpath2 functions are compatible with XSLT 2.0, XSLT 3.0, and XQuery 1.0.
xpath3 functions
All the xpath3 functions are compatible only with XSLT 3.0.
xslt10 functions
The lists below summarize the compatibility of xslt10 functions with transformation languages.
xslt10 | xpath functions
•local-name, name, namespace-uri: XSLT 1.0, XSLT 2.0, and XSLT 3.0.
•lang, last, position: XSLT 1.0.
xslt10 | xslt functions
•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.
