Variables commands

--type:string

--type:number

--type:boolean

--type:datetime

--type:list

--type:dictionary

--type:record

--type:datatable

--type:file

--type:browser

--type:window

--type:credential

Without --type (Keep existing type)

--action:assign

--action:substring

--action:replace

--action:trim

--action:trimleft

--action:trimright

--action:uppercase

--action:lowercase

--action:titlecase

--action:length

--action:isempty

--action:isnumber

--action:tostring

--action:tonumber

--action:toboolean

--action:abs

--action:floor

--action:ceiling

--action:truncate

--action:sqrt

--action:not

--action:keys

--action:values

--action:rowcount

--action:columncount

--action:todatetime

Text → date/time (e.g. 2026-09-30 14:30 or with --format like dd.MM.yyyy).

--action:between

The text after the first --start and before the next --end (empty when either is not found).

--action:base64encode

--action:base64decode

--action:urlencode

--action:urldecode

--action:hash

The hash of the text as lowercase hex.

--action:lastindexof

Position of the last occurrence of --value in the text (-1 when missing).

--action:repeat

The text repeated --count times.

--action:power

The number raised to the power --value.

--action:startswith

--action:endswith

--action:split

--action:concat

--action:padleft

--action:padright

--action:insert

--action:format

--action:regex

--action:regexmatch

--action:regexreplace

--action:contains

--action:remove

String: --start/--length. List: --value.

--action:add

Number: adds --value. List: appends --value.

--action:increment

--action:decrement

--action:subtract

--action:multiply

--action:divide

--action:modulo

--action:min

--action:max

--action:round

--action:random

--action:removeat

--action:removerow

--action:clear

--action:toggle

--action:reverse

List or data table: rows in reverse order. Text: characters reversed.

--action:count

--action:indexof

Text: position of --value (-1 when missing). List: index of the item.

--action:sort

List: sorts the values. Data table (or list of records): sorts the rows by --column.

--action:getat

--action:getrow

--action:join

List: the items as one text with --separator between them. Data table: joined with the table --with on the columns --on (see datatable --action:join).

--action:setat

--action:addkey

--action:removekey

--action:getvalue

--action:containskey

--action:now

--action:adddays

--action:addhours

--action:addminutes

--action:addseconds

--action:addmonths

--action:addyears

--action:datediff

--action:parse

--action:getpart

--action:and

--action:or

--action:addrow

Appends a row: a record variable or a JSON object, e.g. {"Name": "Ali", "Age": 30}. New keys become columns.

--action:columns

Column names as a list.

--action:addcolumn

Adds a column: empty, or with --value for every row (a formula may use $row.Column$).

--action:removecolumn

--action:distinct

Rows without duplicates, as a new data table.

--action:groupby

One row per group with the --aggregates calculations, as a new data table.

--action:lookup

The --return value of the first row whose --column equals --value.

--action:aggregate

The sum, count, average, minimum or maximum of a column.

--action:getcolumn

The values of one column as a list.

--action:getcell

--action:setcell

--action:filter

Rows whose column matches, as a new data table.

--action:trim

Removes spaces, tabs and line breaks from both ends (trim), the start or the end.

--action:trimleft

Removes spaces, tabs and line breaks from both ends (trim), the start or the end.

--action:trimright

Removes spaces, tabs and line breaks from both ends (trim), the start or the end.

--action:uppercase

All letters as capitals.

--action:lowercase

All letters as small letters.

--action:titlecase

The first letter of every word as a capital.

--action:replace

Replaces every occurrence of --old with --new (case-sensitive).

--action:substring

Part of the text: from --start (0 = first character), --length characters (to the end when empty).

--action:between

The text after the first --start and before the next --end (empty when either is not found).

--action:concat

Adds --value to the end of the text.

--action:insert

Inserts --value at position --index (0 = before the first character).

--action:remove

Removes --length characters from --start (to the end when --length is empty).

--action:padleft

Fills the text to --totalwidth characters with --paddingchar at the start (padleft) or the end, e.g. 42 → 00042.

--action:padright

Fills the text to --totalwidth characters with --paddingchar at the start (padleft) or the end, e.g. 42 → 00042.

--action:repeat

The text repeated --count times.

--action:reverse

The characters in reverse order.

--action:split

Splits the text at every --separator into a list.

--action:length

Number of characters.

--action:isempty

true when the text is empty or only spaces.

--action:isnumber

true when the text is a number.

--action:contains

true when the text contains, starts with or ends with --value (case-sensitive).

--action:startswith

true when the text contains, starts with or ends with --value (case-sensitive).

--action:endswith

true when the text contains, starts with or ends with --value (case-sensitive).

--action:indexof

Position of the first --value (0 = first character, -1 when missing).

--action:lastindexof

Position of the last --value (-1 when missing).

--action:regex

Every match of the regular expression --pattern, as a list.

--action:regexmatch

true when the regular expression --pattern matches.

--action:regexreplace

Replaces the matches of --pattern with --replacement ($1 for a group).

--action:format

Puts the text and --args into --format: {0} is the text, {1}… the args, e.g. "Order {0} of {1}".

--action:base64encode

Encodes or decodes the text as Base64 or for a URL.

--action:base64decode

Encodes or decodes the text as Base64 or for a URL.

--action:urlencode

Encodes or decodes the text as Base64 or for a URL.

--action:urldecode

Encodes or decodes the text as Base64 or for a URL.

--action:hash

The hash of the text as lowercase hex.

--action:tonumber

The text as a number (fails when it is not one).

--action:toboolean

The text as true/false (true, yes, 1 / false, no, 0).

--action:todatetime

The text as a date/time (e.g. 2026-09-30 14:30, or with --format like dd.MM.yyyy).

--action:increment

Adds --by to the variable (increment) or takes it away (decrement), in place.

--action:decrement

Adds --by to the variable (increment) or takes it away (decrement), in place.

--action:add

The number plus --value.

--action:subtract

The number minus --value.

--action:multiply

The number times --value.

--action:divide

The number divided by --value (fails on 0).

--action:modulo

The remainder of dividing by --value.

--action:power

The number raised to the power --value.

--action:min

The smaller (min) or larger (max) of the number and --value.

--action:max

The smaller (min) or larger (max) of the number and --value.

--action:round

Rounded to --decimals places (halves away from zero).

--action:floor

Down (floor), up (ceiling) or toward zero (truncate) to a whole number.

--action:ceiling

Down (floor), up (ceiling) or toward zero (truncate) to a whole number.

--action:truncate

Down (floor), up (ceiling) or toward zero (truncate) to a whole number.

--action:abs

The number without its sign.

--action:sqrt

The square root.

--action:random

A random whole number from --min to --max.

--action:format

The number as text in a .NET format, e.g. {0:N2} → 1,234.50, {0:00000} → 00042 (invariant culture).

--action:tostring

The number as text.

--action:toggle

Turns true into false and false into true, in place.

--action:not

The opposite value.

--action:and

true when both the variable and --value are true.

--action:or

true when the variable or --value is true.

--action:tostring

true or false as text.

--action:add

Adds --value to the end.

--action:insert

Inserts --value at --index.

--action:setat

Replaces the item at --index, in place.

--action:remove

Removes the first item equal to --value.

--action:removeat

Removes the item at --index, in place.

--action:clear

Removes every item, in place.

--action:getat

The item at --index.

--action:count

Number of items.

--action:isempty

true when the list has no items.

--action:contains

true when an item equals --value.

--action:indexof

Index of the first item equal to --value (-1 when missing).

--action:sort

Sorts the items (numbers by value, text alphabetically); a list of records by --column.

--action:reverse

The items in reverse order.

--action:join

The items as one text with --separator between them, e.g. a, b, c.

--action:addkey

Sets the value of --key (adds the key when it is new), in place.

--action:removekey

Removes --key, in place.

--action:getvalue

The value of --key (fails when the key is missing).

--action:containskey

true when --key exists.

--action:keys

The keys as a list.

--action:values

The values as a list.

--action:count

Number of keys.

--action:isempty

true when there are no keys.

--action:clear

Removes every key, in place.

--action:now

The current date and time of the agent machine.

--action:parse

A date/time read from text, e.g. 30.09.2026 with --format dd.MM.yyyy.

--action:adddays

Adds days, hours, minutes, seconds, months or years (negative values go back).

--action:addhours

Adds days, hours, minutes, seconds, months or years (negative values go back).

--action:addminutes

Adds days, hours, minutes, seconds, months or years (negative values go back).

--action:addseconds

Adds days, hours, minutes, seconds, months or years (negative values go back).

--action:addmonths

Adds days, hours, minutes, seconds, months or years (negative values go back).

--action:addyears

Adds days, hours, minutes, seconds, months or years (negative values go back).

--action:datediff

Days from --value to the date (fractions for hours; negative when --value is later).

--action:getpart

One part of the date as a number (dayofweek: 0 = Sunday).

--action:format

The date as text in a format, e.g. dd.MM.yyyy, yyyy-MM-dd HH:mm or MMMM yyyy.

--action:addrow

Appends a row: a record variable or a JSON object, e.g. {"Name": "Ali", "Age": 30}. New keys become columns.

--action:removerow

Removes the row at --index, in place.

--action:getrow

The row at --index as a record ($row.Column$).

--action:getcell

The value in row --index, column --column.

--action:setcell

Changes the value in row --index, column --column, in place.

--action:rowcount

Number of rows.

--action:columncount

Number of columns.

--action:columns

The column names as a list.

--action:addcolumn

Adds a column, in place: empty, or with --value in every row. A formula is calculated for each row and $row.Column$ is that row's value, e.g. --value:=$row.Price$ * $row.Qty$.

--action:removecolumn

Removes a column, in place.

--action:getcolumn

The values of one column as a list.

--action:join

Joins the table with the table --with on matching --on columns, as a new data table: the columns of --with are added (a name already taken gets a suffix, e.g. Name_2). Numbers match numbers written as text; text ignores case.

--action:distinct

The rows without duplicates, as a new data table (the first of each is kept); with --columns only those columns are compared.

--action:groupby

One row per group of equal --columns values, with the --aggregates calculations (sum, count, avg, min, max, first, last), as a new data table, e.g. the total per department.

--action:lookup

Finds the first row whose --column equals --value and gives its --return column (or the whole row as a record); --default when no row matches.

--action:aggregate

One number from a column: its sum, count, average (avg), minimum or maximum. Empty cells are skipped; avg/min/max of no values is empty.

--action:filter

The rows whose --column compares to --value, as a new data table.

--action:sort

Sorts the rows by --column.

--action:reverse

The rows in reverse order.

--action:isempty

true when the table has no rows.

--action:clear

Removes every row (the columns stay), in place.