An array is a variable that holds multiple values of the same data type (integer or string).
An array can be used to store data read from a text file, an Excel file or other system containing data. An array is a simple list of text or numeric values (multiple rows only, one column), this is called a one dimensional array and WinTask x64 supports only one dimensional arrays. If there are n columns, you need to use one array for each column. For example, if there are 10 customer names to process, the array would need to have 10 rows. If the data consisted of firstname, lastname, and company name for 10 customers, you would need a 10 rows array for the firstnames, a second 10 rows array for the lastnames and a third 10 rows array for the comany names.
You give an array a name and set its size by the Dim statement. The name of an array ends with a $ character if the array contains strings, does not end with a $ character if the array receives integer values. For example:
declares an array with 10 integer elements.
declares an array with 100 strings.
The Dim statement must be written at the very beginning of the script where it is used.
An array contains a list of data that can be referenced by a number (called an index). The first element of an array is at index 0. You set a value in an array using the = operator:
count(0) = 20
count(1) = 20 + 30
count(2) = 100
count(3) = count(0) + count(2)
MyName$(0) = "First element"
MyName$(1) = "Second element"
MyName$(3) = "Third element"
Array manipulation capabilities
tab1$() = tab2$() ' the entire contents of the 2nd array are copied into the 1st. If the 1st array has more entries than the 2nd, the remaining ones are unchanged.
tab$()="blue" 'All the entries of the array are initialized with "blue"
tab$()="" 'All the entries are emptied
If a$()=b$() then 'Compare the contents of two arrays. This condition is true only if the arrays have the same number of elements AND all corresponding entries in both arrays are equal.
Loop until the first empty string of the array:
tab1$(0) = "First element"
tab1$(1) = "Second element"
tab1$(2) = " Third element"
i = i + 1
until tab1$(i)="" or i=10