How transform a spreadsheet in an array ?

[Rob Cozens]

Ludovic:

>I've a big list like this :
>
>Name	name1	name2	name3
>Data1	1		0		10
>Data2	10		1		0
>Data3	0		1		10
>
>how transform it in one array ?

Geoff:

 >Revolution doesn't support multi-dimension arrays.

While the array routines may not support multi-dimension arrays, it is
possible to create and manipulate arrays of virtually any dimension.

Ludovic's data can be represented as a nine-element array, three lines,
each containing three words.  To find, for example, the fifth element of
the "array", one specifies "word 2 of line 2 of".   To deal with three
dimensions one can reference "word 2 of line 2 of item 1", etc.

If the array data is numeric one can use each character except "0"-"9" and
"-" & "." as an itemDelimiter.  Each itemDelimiter adds a new dimension to
the array.

One note: If using words as an array dimension, make sure the array
contains NO empty words (ie: put "0" into empty words).

Rob Cozens
CCW, Serendipity Software Company

"And I, which was two fooles, do so grow three;
Who are a little wise, the best fooles bee."

from "The Triple Foole" by John Donne (1572-1631)