Variable Commands

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

Command Description

Change Case

Change the letter case within a variable.

Check Type

Check whether the value of a variable is numeric or textual.

Evaluate Expression

Perform complex mathematical or textual operations; or

Evaluate the validity of complex mathematical or logical expressions

Extract Numeric Values

Extract numbers 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

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

Get ASCII Character

There are times when you need a wizard to use a special character, but the character does not appear on the keyboard.

Get Length

Count the characters (including spaces) of the value stored within a variable.

Get Random Number

Generate a random number within the range you specify and store it in a variable.

Get Table Data

Obtain 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 2 parts and place each part into a separate variable.

Table Lookup

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