Skip to main content
The following formatters expect an array attribute as input. An array attribute is a single attribute on an item that has multiple values assigned to it. Array attributes in Script are denoted by the pound sign (#) at the end of the attribute (for example tmp.myarrayitem#). See Selecting Attribute Values for more information.
  • The # symbol is not needed when you are passing in the array attribute to any of these formatters.
  • The square brackets around the optional parameters of some formatters are not required. They are there to denote that the parameter is optional.

ā€‹
arrayaverage([integer_rounding_mode][decimal_places])

Returns the average of the attribute array elements.
  • rounding_mode: Specifies the rounding behavior for numerical operations capable of discarding precision. Accepted values are: ToEven, AwayFromZero, ToZero, ToNegativeInfinity, ToPositiveInfinity. The default rounding strategy used is based on your operating system. .NET uses ToEven, and Java uses Half Even.
You can also specify a global RoundingMode environment variable and provide one of the rounding_mode values as its value. When you do this, uses that rounding mode any time a rounding_mode has not been explicitly specified in the formatter. To be more specific, checks for values in this order:
  1. rounding_mode input
  2. The RoundingMode environment variable
  3. The default as determined by the operating system, as described above

ā€‹
arrayfind(substring)

Returns the index at which the string is found in the attribute array. The index is 1-based.
  • searchstring: The string to search for in the original value.

ā€‹
count(substring)

Returns the number of occurrences in the attribute value of a substring specified by the first parameter.
  • substring: The substring to search for in the attribute value.

ā€‹
endswith(substring[, iftrue][, iffalse])

Determines whether the attribute value ends with the specified parameter. Returns true (or iftrue) if the attribute ends with the value, and false (or iffalse) if not.
  • substring: The string expected at the end.
  • iftrue: The optional value returned if the attribute value ends with the parameter value.
  • iffalse: The optional value returned if the attribute value does not end with the parameter value.

ā€‹
implode([separator])

Implodes multiple values to a string separated by a separator.
  • separator: The optional separator.

ā€‹
join([separator])

Joins multiple values to a string separated by a separator.
  • separator: The optional separator.

ā€‹
match(pattern[, index][, option])

Searches the string represented by the attribute value for an occurrence of the regular expression supplied in the pattern parameter.
  • pattern: The regular expression pattern to match.
  • index: The optional numbered index of the match to return. The default is 0.
  • option: The optional comma-separated list of regular expression options. Some of the commonly used options are IgnoreCase, Multiline, Singleline, and IgnorePatternWhitespace.
Returns a string with all the values of the attribute concatenated using the specified delimiter.
  • delim: The optional delimiter to separate values with. The default is a comma.