Variable commands

Variable commands are dynamic advanced commands that allow you to manage and manipulate data within your wizard. These commands enable you to create, change, and use variables to perform various operations. They are essential in every wizard, ensuring efficient data handling during the wizard's run.

For more information on general variable usage, refer to the variables page.

Before you begin:

Refer to the table below for a detailed overview of each command and its respective functionalities:

Command Description

Change case

Change the case of a variable's value to uppercase or lowercase, or capitalize each word.

Check type

Check if a variable's value is numeric or textual.

Evaluate expression

Perform complex mathematical or textual operations, or evaluate the validity of complex expressions.

Extract numeric values

Extract numeric values from a variable that contains a mix of text and numbers.

Find

Find the location of a specific text string within a variable, or find all text matching a regular expression within a variable.

Get array data

Get specific information from a variable containing a string of items (an "array").

Get ASCII character

Retrieve a specific ASCII character.

Get length

Count the characters, including spaces, in a variable's value.

Get random number

Generate a random number within a specified range and store it in a variable.

Get table data

Get specific information from a variable containing a table.

Mathematics

Perform simple mathematical calculations (using constants and/or values copied from other variables) and place the result into a new or existing variable.

Remove blank spaces

Remove blank spaces (including <Space>, <Tab>, and <Enter>) from the beginning, end, or both ends of the variable you specify.

Replace

Replace a specific text string within a variable, or replace text matching a regular expression within a variable.

Reverse

Reverse the value of a variable, character by character.

Set value

Create a new variable and set its value, or set the value of an existing variable.

Split

Divide the contents of a variable into two parts and place each part into a separate variable based on a specified delimiter or character position.

Table lookup

Search for a value in a table (the "lookup value") and retrieve a corresponding value.

When using the Variable commands, there are some considerations and limitations to be aware of. These are relevant to specific commands and similar to general variable limitations. For more detailed information, refer to the variables page or each specific command's documentation.

General considerations

  • Variable names are not case-sensitive.

  • Variables can include spaces but not special characters (e.g., ! @ # $ % ^ & ( ) / < > - = | ).

  • Undefined variables contain an empty string.

  • The value of a variable is always treated as a string, even if it represents a numeric value.

Mathematical operations

  • Numbers, including those with currency symbols, are treated as non-numeric.

  • Standard mathematical order of operations applies. Use parentheses to force order of precedence. For example:

    • 120/10 + 2 = 14

    • 120/(10+2) = 10

  • If one or both values entered are non-numeric, the wizard will return an empty result in the specified variable.

  • Use the Check type command to validate that variable values are numeric before using them in mathematical calculations.