Functions

You can call functions from within the template files and embed the call result easily by writing {%=functionName(arg1, arg2, arg3, ...)%} expression in the document template.

This is a short description of the functions implemented in Stencil:

• ceil
• coalesce
• currency
• date
• decimal
• empty
• floor
• format
• formatWithLocale
• hideColumn
• hideRow
• html
• integer
• join
• joinAnd
• length
• list
• lowercase
• map
• percent
• range
• round
• str
• switch
• titlecase
• uppercase
• xml
• contains
• sum

Basic Functions

Coalesce

Accepts any number of arguments, returns the first not-empty value.

Exampe:

• to insert the first filled name value: {%=coalesce(partnerFullName, partnerShortName, partnerName)%}
• to insert the price of an item or default to zero: {%=coalesce(x.price, x.premium, 0)%}

Decimal

Converts parameter to decimal number. Returns null for missing value.

Empty

Decides if a parameter is empty or missing. Useful in conditional statements.

Example:

{%if empty(userName) %}Unknown User{%else%}{%=userName%}{%end%}

If the value of userName is missing then Unknown User will be inserted, otherwise the value is used.

The empty() function is useful when we want to either enumerate the contents of an array or hide the whole paragraph when the array is empty.

List

Creates a list collection from the supplied arguments. Intended to be used with other collections functions.

Integer

Converts parameter to integer number. Returns null for missing value.

Map

Selects values under a given key in a sequence of maps. The first parameter is a string which contains what key to select:

• It can be a single key name
• It can be a nested key, separated by . character. For example: outerkey.innerkey
• It can be used for selecting from multidimensional arrays: outerkey..innerkey

Example use cases with data:

{"items": [{"price": 10, "name": "Wood"}, {"price": "20", "name": "Stone"}]}

• join(map('name', items), ','): to create a comma-separated string of item names. Prints Wood, Stone.
• sum(map('price', items)): to write the sum of item prices. Prints 30.

String functions

These functions deal with textual data.

Join

Joins a list of items with an optional separator.

Example: call join(xs, ",") to join them with a comma.

Example: call join(xs) to just concatenate the items.

JoinAnd

Joins a list of items using two separators. The first separator is used to join the items except for the last item. The second separator is used to join the last item. When two items are supplied, then only the second separator is used.

Example: call join(xs, ", ", " and ") to get "1, 2, 3 and 4".

Date

Formats a date value according to a given format string.

When called with two arguments:

1. First argument is a format string.
2. Second argument is a string containing a date value.

With three arguments:

1. First argument is an IETF Language Tag string.
2. Second argument is a format string.
3. Third argument is a string containing a date value.

Example:

1. This example formats the value of birthDate as a date string: {%=date("yyyy-MM-dd", birthDate) %}
2. With locale: date("hu", "YYYY MMMM d", "2021-05-20") evaluates to "2021 május 20".

Also, try these formats strings:

• "yyyy-MM-dd HH:mm:ss" for example: 2018-02-28 13:01:31
• "EEE, dd MMM yyyy HH:mm:ss zzz" (also known as RFC1123)
• "EEEE, dd-MMM-yy HH:mm:ss zzz" (a.k.a. RFC1036)
• "EEE MMM d HH:mm:ss yyyy" (ASCTIME)
• "yyyy-MM-dd'T'HH:mm:ss.SSSXXX" (ISO8601)

HTML

It is possible to embed text with basic dynamic formatting using HTML notation. The HTML code will be converted to OOXML and inserted in the document.

Stencil uses a simple parsing algorithm to convert between the formats. At the moment only a limited set of basic formatting is implemented. You can use the following HTML tags:

• b, em, strong for bold text.
• i for italics.
• u for underlined text.
• s for strikethrough text.
• sup for superscript and sub for subscript.
• span elements have no effects.
• br tags can be used to insert line breaks.

The rendering throws an exception on invalid HTML input or unexpected HTML tags.

Example:

Write the following to embed the content of x as HTML in the document:

• {%=html(x) %}.

XML

You can embed custom xml fragments in the document with the xml() function. The parameter is a string containing the XML nodes to insert.

Format

Calls String.format function.

FormatWithLocale

Like format but first parameter is an IETF Language Tag. For example: formatWithLocale("hu", "%,.2f", number)

Example:

This example formats the value of price as a price string: {%=format("$ %(,.2f", price) %}. It may output $ (6,217.58).

Length

The length(x) function returns the length of the value in x:

• Returns the number of characters when x is a string.
• Returns the number of elements the x is a list/array.
• Returns the number of key/value pairs when x is an object/map.

Returns zero when x is null.

Lowercase

The lowercase(x) function turns its string argument into a lowercase string. For example: lowercase("HELLO") returns "hello".

Str

The str(x) functions convers its non-null arguments into a string. Returns an empty string when all arguments are null.

Numeric functions

Round

Expects one number argument. Rounds the argument to the closest integer. Usage: round(x). For example round(1.1) returns 1.

Floor

Expects one number argument. Rounds the argument to the closest integer that is not greater than than the argument. Usage: floor(x)

Ceil

Expects one number argument. Rounds its argument to the closest integer that is not smaller than the argument. Usage: ceil(x)

Contains

Expects two arguments: a value and a list. Checks if list contains the value. Usage: contains("myValue", myList)

Sum

Expects one number argument containing a list with numbers. Sums up the numbers and returns result. Usage: sum(myList)