1. Automate
2. Documentation
3. Functions

Functions

The following functions are available for use in expressions:

• abs
  Absolute value.
• acos
  Arc cosine of value.
• asin
  Arc sine of value.
• atan
  Arc tangent of value.
• atan2
  Arc tangent of quotient.
• base64Decode
  Decode Base64.
• base64Encode
  Encode Base64.
• bearing
  Bearing to a location.
• ceil
  Smallest integer greater than or equal to value.
• celsius
  Fahrenheit to Celsius.
• char
  Unicode codepoint to text.
• cliEncode
  Encode command line text.
• clock
  Time of clock.
• coalesce
  First non-null value.
• colorRecode
  Convert color.
• concat
  Concatenate arrays.
• contains
  Array, dictionary or text contains value.
• convType
  Conversion type of dictionary entry.
• coordFormat
  Format a coordinate.
• copy
  Clone a value.
• cos
  Trigonometric cosine of an angle.
• crc32
  CRC32 checksum.
• ctz
  Count trailing zero bits.
• date
  Year, month, day to timestamp.
• dateFormat
  Format a date and/or time.
• dateParts
  Split timestamp into date parts.
• dateParse
  Parse a date.
• disjoint
  Values not present in both containers.
• distance
  Distance between locations.
• distinct
  Remove duplicate elements.
• declination
  Declination of the horizontal component of the magnetic field.
• durationFormat
  Format a duration.
• exp
  Euler’s constant raised to the power of value.
• except
  Values not present in other container.
• extend
  Combine dictionaries.
• fahrenheit
  Celsius to Fahrenheit.
• fileUri
  File path to URI.
• filter
  Filter an array or dictionary of null values.
• findAll
  Text regular expression matching.
• floor
  Largest integer less than or equal to value.
• glob
  Text pattern matching.
• hexDecode
  Decode hex.
• hexEncode
  Encode hex.
• indexOf
  Index of element in array.
• intersect
  Values present in both containers.
• jsonDecode
  Parse JSON.
• jsonEncode
  Encode JSON.
• join
  Join array elements with a delimiter.
• keys
  Dictionary keys.
• levenshtein
  Text similarity.
• localTime
  Adjust timestamp to local time.
• log
  Natural logarithm (base E) of value.
• lowerCase
  Text to lower case characters.
• matches
  Text regular expression matching.
• max
  Greater value.
• md5
  MD5 cryptographic hash.
• mimeType
  Data type from a filename/URI.
• min
  Lesser value.
• numberFormat
  Format a number.
• phoneq
  Compare phone numbers.
• phoneFormat
  Format a phone number.
• pow
  Raised to the power of number.
• random
  Generate pseudo-random number.
• replaceAll
  Text regular expression search and replace.
• reverse
  Reverse array elements.
• round
  Round to the nearest integer.
• sha1
  SHA-1 cryptographic hash.
• sha256
  SHA-256 cryptographic hash.
• shuffle
  Shuffle array elements.
• slice
  Sub-section of array
• sift
  Filter container by indices/keys.
• sin
  Trigonometric sine of an angle.
• sizeFormat
  Format a byte unit.
• sort
  Sort array.
• split
  Text split around matches of regular expression.
• sqlEncode
  Encode an SQL value.
• sqrt
  Positive square root of value.
• storage
  External storage directory.
• substr
  Part of text.
• sum
  Sum of array or dictionary values.
• tan
  Trigonometric tangent of an angle.
• time
  Time in seconds.
• timeMerge
  Combine date and time.
• timePart
  Timestamp time of day.
• trim
  Omit leading and trailing whitespace.
• trunc
  Integral part of value.
• type
  Value type.
• undead
  Combine a “dead” key and basic Unicode character code.
• union
  Combined values.
• unorm
  Normalize text to its Unicode Normalization Form.
• upperCase
  Text to upper case characters.
• urlDecode
  Decode URL.
• urlEncode
  Encode URL.
• utcTime
  Adjust timestamp to UTC time.
• uuid4
  Generate a version 4 UUID.
• values
  Dictionary values.
• vercmp
  Compare version strings.
• xmlDecode
  Parse XML.
• xmlEncode
  Encode XML.
• xpathEncode
  Encode XPath string literal.