Automate > Documentation > 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.
   colorRecode
   Convert color.
   concat
   Concatenate arrays.
   contains
   Array, dictionary or text contains value.
   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.
   extend
   Merge dictionaries.
   fahrenheit
   Celsius to Fahrenheit.
   findAll
   Text regular expression matching.
   filter
   Filter an array or dictionary of null values.
   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.
   shuffle
   Shuffle array elements.
  • slice : Sub-section of array
  • sift : Filter an array by indices or a dictionary by keys.
  • sin : Trigonometric sine of an angle.
  • 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.
   upperCase
   Text to upper case characters.
  • urlDecode : Decode URL.
  • urlEncode : Encode URL.
  • utcTime : Adjust timestamp to UTC time.
  • values :Dictionary values.
  • vercmp : Compare version strings.
  • xmlDecode : Parse XML.
  • xmlEncode : Encode XML.
最終更新:2019年01月13日 17:23